seeking php mysql search class, w phrase, relevency and boolean abilities

[unknowncat]

Hello,

 

I've been spending too long searching for a good solution, i wonder if anyone on here might be able to help.  I'm working on a few sites that need search functionality, and i already have a simple LIKE %$searchter% type query.  But we need more advanced search abilities!  like multiple keywords, results ordered by relevency, boolean searches, etc.  We're querying the mysql database for the 'title' and 'description' fields..

 

Can anyone recommend a good php class or script to use?

 

Thanks in advance!

[zq29]

All that is possible with MySQL's full-text search functionality, but it might be worth looking into using a full-text search engine like Sphinx too.