search table for apostrophe

[crmpicco]

SELECT * FROM `dbo_tp_countryname` where CountryName like '%'''%'


How do i search a table which has a apostrophe in it? I have tried the above, but it doesnt work.

My error is
Error: You have mismatched `'`

[Kid Charming]

You need to escape the apostrophe you're searching for:


SELECT
foo
FROM
table
WHERE
bar LIKE '%\'%'