PunBB Forums — MySQL search

Re: MySQL search

null@example.com (Mastodon) — Sun, 12 Feb 2006 00:20:59 +0000

Rickard wrote:

elbekko wrote:
Use queries with the LIKE statement
No, that will not use fulltext indexing. You need to add a fulltext index to the affected columns and then change the search script to issue queries on the form MATCH (field) AGAINST('searchtext'). I think there was a mod for this. Not sure though.

I found this one, but it doesn't attempt switching the search method entirely.

I've had a closer look at search.php, and I think I'm going to hold back on attempting a job like this if no one else has even tried it before. I expect my hosting costs to go through the roof, but I'll prune some posts or something if I have to.

Thanks.

Re: MySQL search

null@example.com (hcgtv) — Sat, 11 Feb 2006 17:24:31 +0000

Rickard,

Any thoughts on using fulltext search if the database selected on install is MySQL?

Re: MySQL search

null@example.com (Rickard) — Sat, 11 Feb 2006 17:08:31 +0000

elbekko wrote:

Use queries with the LIKE statement

No, that will not use fulltext indexing. You need to add a fulltext index to the affected columns and then change the search script to issue queries on the form MATCH (field) AGAINST('searchtext'). I think there was a mod for this. Not sure though.

Re: MySQL search

null@example.com (elbekko) — Sat, 11 Feb 2006 12:40:07 +0000

Use queries with the LIKE statement

MySQL search

null@example.com (Mastodon) — Fri, 10 Feb 2006 21:22:14 +0000

Can anyone explain to me the best way to modify search.php to use MySQL's proprietary fulltext search instead of PunBB's database-independent one? Or, if anyone has the modified version laying around, feel free to send it along.