UNIDAC MYSQL Command SELECT LIKE

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
paulohenrique7010
Posts: 1
Joined: Fri 19 Jul 2019 16:50

UNIDAC MYSQL Command SELECT LIKE

Post by paulohenrique7010 » Fri 19 Jul 2019 16:56

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

ViktorV
Devart Team
Posts: 2794
Joined: Wed 30 Jul 2014 07:16

Re: UNIDAC MYSQL Command SELECT LIKE

Post by ViktorV » Mon 22 Jul 2019 06:13

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.

Post Reply