My filter value include ' , how to write correct scripts

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.

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