How to query in Dremio is the filter value include a '?

1

Dears, For example :
SELECT field1 FROM tablename WHERE field1 = ‘val’ue’ ;

If I search like above, the dremio will report SQL prase error. Is anyone can help on this? How to write is correct about the ‘val’ue’ .

Thanks very much.

2

You can escape the single quote by adding another single quote:

SELECT field1 FROM tablename WHERE field1 = 'val''ue';

I believe this is fairly standard SQL behavior.

3

Hi @steven ,thank you very much, it work.