My filter value include ' , how to write correct scripts

1

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

Hello, As Steven pointed in another thread, for every single quote add an extra single quote in the value field.