mysql PDO how to bind LIKE
- by dmontain
In this query
select wrd from tablename WHERE wrd LIKE '$partial%'
I'm trying to bind the variable '$partial%' with PDO. Not sure how this works with the % at the end.
Would it be
select wrd from tablename WHERE wrd LIKE ':partial%'
where :partial is bound to $partial="somet"
or would it be
select wrd from tablename WHERE wrd LIKE ':partial'
where :partial is bound to $partial="somet%"
or would it be something entirely different?