Contains statement Query I need to check the string with the column if the column contains that string or not.

example:String 'how to make pizza'  and the column if has 'pizza' i need to fetch that..
like

SELECT * FROM event WHERE ('%how to make pizza%' LIKE EventName);


any idea plz..
You have to take into consideration the Full-Text Search Functions


  Full-text searching is performed using MATCH() ... AGAINST syntax. MATCH() takes a comma-separated list that names the columns to be searched. AGAINST takes a string to search for, and an optional modifier that indicates what type of search to perform. The search string must be a string value that is constant during query evaluation. This rules out, for example, a table column because that can differ for each row. 


The initial setup and configuration is very simple