I want to seach this string exactly: ('TEST')
sel * from database.test where feld like '@'TEST@'' ESCAPE'@'.
Is this not possible with Single Quotes ?
sel * from db.table where field like '''TEST''%' ;
no error, but also no rows
SEL * FROM .... WHERE C1 LIKE '%''FOOD''%'
works now, thanks