How do I select SQL if I want to display all records which contain at least
one of the values to be compared.
I made a table which have a field of keywords.
The Keywords are those to be used as a clue values when I query.
They are several comma-delineated clue words such as
- shoes,nike,addidas,sports,snickers,health -
In case I want to search all the records which contain word "sports" in any
place of keyword field, How do I do that?
I'd like to make an search form similar to the Yahoo, Infoseek....
Would you please help me out?