Page 1 of 1

UNIDAC MYSQL Command SELECT LIKE

Posted: Fri 19 Jul 2019 16:56
by paulohenrique7010
Hello everyone,
I did not find it in the documentation or google.
I have an sql code
"select * from user where username like '% a%'.
every time I run any sql command with the "like", I get the following error:
"Unknown column '% A%' in where clause"
and if I run in the DB, I get the result

translate by Google
From Portuguese Brasil

Re: UNIDAC MYSQL Command SELECT LIKE

Posted: Mon 22 Jul 2019 06:13
by ViktorV
This error may occur if the ` rather than ' character is used in the LIKE construct.
If this does not help in solving the problem, please, compose a small sample demonstrating the described behavior and send it to us using the contact form https://www.devart.com/company/contactform.html including scripts for creating and populating database objects.