How to include apostrophe (') in MySql Update statement?

Question

I have a update query
Eg: 'update table1 set text="Sample text'"'
How to include apostrophe(') in the query without running into Parse error 1064

Doubling up the single quote is usually the way to do it, e.g. `update table1 set text = 'Sample text''';` — Tim Biegeleisen, Nov 06 '17 at 08:53

score 1 · Answer 1 · answered Nov 06 '17 at 08:53

1

you have to escape the special characters with a back slash "\"

\'

answered Nov 06 '17 at 08:53

RemedialGuns

1 Answers1