• Registered: 2006-01-20
  • Posts: 18

Topic: MySQL search

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. smile

  • From: Leuven, Belgium
  • Registered: 2005-06-14
  • Posts: 2,653

Re: MySQL search

Use queries with the LIKE statement

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: MySQL search

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.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

4 Reply by hcgtv

  • hcgtv
  • hcgtv
  • Senior Member
  • Offline
  • From: Charlotte, NC
  • Registered: 2004-06-25
  • Posts: 1,991

Re: MySQL search

Rickard,

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

PHPCrossRef . TXP Make . TXP Themes . TXP Tags . TXP Planet . We Love TXP

hcgtv's Website

  • Registered: 2006-01-20
  • Posts: 18

Re: MySQL search

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.