Using sql inside Notebook using question marks

[JensV]

Hi all,

I have a very quick question that I hope someone can help with.

I want to execute a very simple sql statement like 

%sql
select * from  json.`/Volumes/adfmeta/Objects.json`
where ObjectName like '%SGm$RITWebsader$911a%'

However, the sql does not find anything and ask for ::parm insted

How do i accept that my whare clause has question marks????

[JAHNAVI · Accepted solution]

Hi @JensV , 
Question marks are used as parameter placeholders, so could you please try to escape the question mark using Backslashes?

select * from json.`/Volumes/adfmeta/Objects.json` where ObjectName like '%SGm\\$RITWebsader\\$911a%'

Alternatively, we can use regex equation like this: SELECT * FROM json.`/Volumes/adfmeta/Objects.json` WHERE ObjectName RLIKE '.*SGm\\$RITWebsader\\$911a.*'