How to escape a single quote in presto?

by lindsey.homenick , in category: MySQL , 5 months ago

How to escape a single quote in presto?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by daisha , 5 months ago

@lindsey.homenick 

To escape a single quote in Presto, you can use two single quotes in a row.


For example, if you wanted to insert the value "I can't do it" into a query, you would write it as:


"I can''t do it"


This way, Presto will interpret the two single quotes as a single literal single quote character.

Related Threads:

How to escape a semicolon in presto?
How to group time column into 5 second intervals and count rows using presto?
How to get latest 3 months records in presto sql?
How to escape quotes in PHP?
How to escape the apostrophe in javascript?
How to escape special characters in oracle?