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
UNIDAC MYSQL Command SELECT LIKE
Re: UNIDAC MYSQL Command SELECT LIKE
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.
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.