Apostrophe replacement in mysql query

Question

I have column names (notes) as

Notes:

John's table

Smith Window 

The column contains an apostrophe. I am trying to run 2 queries.

• Select a query to get the column entries with an apostrophe.
• Update those with an apostrophe with an empty string, i.e. Replace John's table with John's table

select notes from table 1, where notes are of type "%";

I get a syntax error, any help would be great.

Answer 1

Apostrophe escape with a backslash;

 select notes from table1 where notes like '%\'%'; 

And to update, use REPLACE ()

 UPDATE table1 SET notes = REPLACE(notes, '\'', ''); 

Answer 2

Have you tried:

 select notes from table1 where notes like "'%";