write a sql query for searching using pattern matching.
my query is SELECT * FROM tbl_candidate WHERE `job_title` LIKE '%%' OR `candidate_city` LIKE '%glassboro%'.
it gives wrong output