i'm making a searcher for my site and this works fine with one word querys
$consulta = mysql_query("SELECT * FROM recetas WHERE (titulo LIKE '%$busqueda%' OR intro LIKE '%$busqueda%' OR extra LIKE '%$busqueda%') ORDER BY id DESC");
But if i type 'two words' it doesn't give me result, $busqueda it's result from a given through $_POST['TERM']
any idea what i'm missing?
SOLVED
i was missing to encode the variable to URI... oops haha THANKS!
解决方案
Think of how your query will look at the end:
Select ... where '%two words%. ...
If you want to search for words like that, you'll have to massage the data to look more like:
... Like '%two%words%'
... Like '%two%' or like '%words%'
depending on your exact search requirements