nri-flex icon indicating copy to clipboard operation
nri-flex copied to clipboard

Impossible to use the '%' character in a db query (MySQL)

Open albertoakg opened this issue 1 year ago • 0 comments

Description

It's not possible to use the % character in a query using MySQL driver. My query is a matter like that: SELECT filed1, filed2, filed3 FROM table1 WHERE field2 LIKE '%abcdef%' But in this form, it doesn't work. Instead, it works well if I don't use the LIKE with %. I already tried to escape this character with \ and with ", but it continues to not work.

Expected Behavior

I expect that the query works with %

albertoakg avatar Jul 25 '22 12:07 albertoakg