MySQL problem - Invalid column name ????

Question

Can someone please help - I'm about ready to tear out my hair over this one ;(

Invalid column name '%Discover%'.

SELECT * FROM mdl_course_sections WHERE summary LIKE "%Discover%" AND course = 22

I'm looking for 'Discover' - but why is it treating it as a column???

Thanks!

Answer 1

Put it in single quotes:

SELECT * FROM mdl_course_sections WHERE summary LIKE '%Discover%' AND course = 22

Answer 2

SELECT * FROM `mdl_course_sections` WHERE `summary` LIKE '%Discover%' AND `course` = 22

Answer 3

try ' instead of " for values.