MySQL: Column Contains Word From List of Words

Posted by mellowsoon on Stack Overflow See other posts from Stack Overflow or by mellowsoon
Published on 2011-01-14T06:51:29Z Indexed on 2011/01/14 6:53 UTC
Read the original article Hit count: 276

Filed under:
|
|

I have a list of words. Lets say they are 'Apple', 'Orange', and 'Pear'. I have rows in the database like this:

------------------------------------------------
|author_id   |  content                        |
------------------------------------------------
| 54         | I ate an apple for breakfast.   |
| 63         | Going to the store.             |
| 12         | Should I wear the orange shirt? |
------------------------------------------------

I'm looking for a query on an InnoDB table that will return the 1st and 3rd row, because the content column contains one or more words from my list. I know I could query the table once for each word in my list, and use LIKE and the % wildcard character, but I'm wondering if there is a single query method for such a thing?

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql