search

[________]

Hi there,
I got a bit of a problem. Im building a search script, but im not sure what function to use... I have tried both LIKE and REGEXP... but the problem is that the users can search for more than one word - and the script needs to find all rows where it matches the search word... independent of the order of the words.
And then find all the rows where one or more words match...

Need help!!!!

[steadyguy]

tried JOINing LIKE/REGEXP searches?

[JdL]

Use either AND or OR in your SELECT:

When a search is performed on PHP and FORUM, the resulting statement should be:

SELECT * FROM table WHERE searchfield LIKE '%PHP%' AND searchfield LIKE '%FORUM%'

This would give all records where PHP and FORUM are in the searchfield. The get either, use OR. You can combine AND en OR as much as you like - to search for more than one field for instance. You can also combine searches by placing them between brackets, like this:

SELECT * FROM table WHERE (searchfield1 LIKE '%PHP%' OR searchfield2 LIKE '%PHP%') OR (searchfield1 LIKE '%FORUM%' OR searchfield2 LIKE '%FORUM%').

This last statement will return any row that has either PHP or FORUM (or part of it) in either searchfield1 or searchfield2.

On several sites I split the searchstring into an array and traversed the array to build the SQL statement, but I am sure there are many other ways of doing this.

Hope it helps.