How to escape a single quote in presto?

by lindsey.homenick , in category: MySQL , 7 days ago

How to escape a single quote in presto?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by daisha , 6 days 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.