How to escape a semicolon in presto?

by elise_daugherty , in category: Third Party Scripts , 4 months ago

How to escape a semicolon in presto?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by giovanny.lueilwitz , 4 months ago

@elise_daugherty 

To escape a semicolon in Presto, you can use double quotation marks (""). For example, if you want to include a semicolon within a string, you can enclose the string within double quotation marks to escape the semicolon.


Here is an example:


SELECT 'This is a string with a semicolon; escaped by double quotation marks';


In this example, the semicolon within the string is escaped by enclosing the entire string in double quotation marks. This will prevent the semicolon from being interpreted as a statement terminator in the Presto query.

Related Threads:

How to escape a single quote 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?