mySQL WHERE.. OR query

Question

I want to execute a query on a database to select all rows in the 'Event' table where the 'about' section has any of the following words in it: strokestown, arts, day. My query, shown below is only getting rows that have the first word, strokestown in them. How do I make it search for all words?

SELECT *
  FROM Event
 WHERE about LIKE 'strokestown%'
    OR about LIKE 'arts%'
    OR about LIKE 'day%';

Thank you for your time!!

Jim

Answer 1

Place the wildcard character, '%', at the start as well as the end of the your search terms:

SELECT * 
FROM Event 
WHERE about LIKE '%strokestown%' 
OR about LIKE '%arts%' 
OR about LIKE '%day%';

Answer 2

SELECT * FROM Event
WHERE about LIKE '%strokestown%'
    OR about LIKE '%arts%'
    OR about LIKE '%day%'

Put a % before and after the keywords.