how to use parameter on mysqlcommand using LIKE on statment

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
janaya
Posts: 1
Joined: Thu 02 Mar 2006 20:28

how to use parameter on mysqlcommand using LIKE on statment

Post by janaya » Thu 02 Mar 2006 20:31

how to use myslcommand.parameter on STATEMENT like

Example SELECT * FROM autor where nombre like '%FRANK%'

Thank's

Javier anaya Ramirez

Serious

Post by Serious » Fri 03 Mar 2006 13:18

Code: Select all

MySqlCommand command = new MySqlCommand("select * from dept where dname like :p1", connection);
command.Parameters.Add("p1", "%re%");

Post Reply