How to search for a specific word in a row in MYSQL?
Posted
by user220755
on Stack Overflow
See other posts from Stack Overflow
or by user220755
Published on 2010-06-17T19:01:11Z
Indexed on
2010/06/17
19:13 UTC
Read the original article
Hit count: 181
I have a row that has keywords in this way (keyword1, keyword2, keyword3) separated by commas as shown. When a user signs in, you know that he wants information about (keyword1, keyword3). Now, I have another table that has bunch of information related to different keywords, this table has a row called (keywords) which indicates if this information is suitable for which keyword. How do I render for the user the information he needs depending on the keywords.
In other words, if the user wants information about (keyword3, keyword1) how do I go to the (information) table and find all the information that has the word (keyword1) or the word (keyword3) in the row (keyword)?
Sorry if this is complicated (my explanation) but I tried my best to explain it.
Thank you in advance :)
© Stack Overflow or respective owner