View Single Post
Old 12-07-2004, 08:43 PM   #1
leonardburton
Green Mole
 
Join Date: Dec 2004
Posts: 10
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
leonardburton is offline   Reply With Quote