PHP search script

[jimoblak]

I have constructed a very basic search function that can only handle one word or exact phrase searches with an SQL command like:

SELECT * FROM SiteDB WHERE (keywords LIKE '%$user-entered-word-or-phrase%')";

My next task is to allow advanced searches for non-adjacent words using the following input from the user:

"" //exact phrases
OR //either word
AND //both words
NOT //exclude word

Would anyone know of good resources for writing search scripts? Or would anyone have any samples?

 

[BB101]

Use SQL's full text search --BB