PHP Search systems that will search mysql

Hi all,

I need a search system that will do more than just basic keyword searching (boolean etc) BUT doesnt http spider a site, instead it will search a mysql database with fields i specify.

It can even index the site and create its own flat file database.
The key is that it needs to work with mysql and not spider a site.

Does anyone know of a system?

I'm pretty sure mysql has features like this built in that alow you to search a database

Code: Select all

SELECT * WHERE `feild1` LIKE '%word%' OR `feild2` LIKE '%word%'

is one way of doing it, i'm sure there are others.

Ye with a variety of connections to mysql you can make a pretty sophisticated script.

Do you mean that you hold the text for the pages in the database and you want to be able to do a full text search or are you wanting to search specific, single element fields, akin to what has already been indicated?