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
PHP Code:
WHERE interests REGEXP 'sports|pub' 
is that the better?