nri-flex
nri-flex copied to clipboard
Impossible to use the '%' character in a db query (MySQL)
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 %