How do I escape a single quote in Presto?

sql presto
scottshepard picture scottshepard · Sep 20, 2017 · Viewed 12.8k times · Source

How can I escape a ' (single quote) in Presto?

This is where I am trying to use it

select count(*) as count from uploads where title not in ('Driver's License')

I've tried the usual escapes: , 'Driver\'s License', "Driver's License", E'Driver\'s License' but nothing seems to work. Presto's docs are vague. Anyone know?

Answer

scottshepard picture scottshepard · Sep 20, 2017

The answer, provided by a_horse_with_no_name, is to use another '.

'Driver''s License'

Related questions

Presto SQL - Converting a date string to date format

I'm on presto and have a date formatted as varchar that looks like - 7/14/2015 8:22:39 AM I've looked the presto docs and tried various things(cast, date_format, using split_part to parse and then cast) and am not getting this …

Read More
Presto check if NULL and return default (NVL analog)

Is there any analog of NVL in Presto DB? I need to check if a field is NULL and return a default value. I solve this somehow like this: SELECT CASE WHEN my_field is null THEN 0 ELSE my_field …

Read More
Athena greater than condition in date column

I have the following query that I am trying to run on Athena. SELECT observation_date, COUNT(*) AS count FROM db.table_name WHERE observation_date > '2017-12-31' GROUP BY observation_date However it is producing this …

Read More