how to do "reverse like" search in mysql?
Greetings,
Would anyone know if this can be done in an SQL statement?
At the bottom of my PHPDIG search results I have special links inserted for certain queries. I am currently only filtering for certain one word phrases (which was very easy) but I want to have two word + phrases.
For example, if in the MYSQL table I have stored:
one two three
and the PHPDIG search query is:
one two three four
I want it to return the special link for "one two three."
I tried "select link from table where '$query' like keyword" but obviously that didnt work.
Is there a way to do that without having to put all the keywords in an array and loop through it?
Thanks,
Leonard
|