Accoring to a string that contain words separated from a space, in mySql i need to search all records in which the title contains at least one those words.
There are a specific syntax for do that, or i've to generate a WHERE IN (word1, word2, word3...) clause?
And there are a solution basend on the LIKE clause?
Searching on internet i found this solution too
is that the better?PHP Code:
WHERE interests REGEXP 'sports|pub'