How to escape a single quote in a string?
I have a string in my database that has a ' character in the string. I'm searching for the record with this string in a field - and I can't escape the single quote character.
where type='new record'
and payload.normalization='aller au boulevard gouin ouest et l' avenue le mesurier montréal'
How can i escape the ' in l' avenue?