MySQL Parameterized Query using Like

Question

I want to run a query like this in MySQL:

select * from table where column1 like '%searchdata%'

But I want to use a parameter to pass in the search text. Is this possible? This doesn't seem to work:

select * from table where column1 like '%?Parameter%'

Chad Birch · Accepted Answer · 2009-04-21 17:20:56Z

46

The % symbols need to be inside the parameter value, so it's something more like:

select * from table where column1 like ?;

And then you set the parameter to:

%searchText%

answered Apr 21, 2009 at 17:20

Chad Birch

75k24 gold badges155 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ahh, the sound of my hand hitting my forehead.