Using LIKE in bindParam for a MySQL PDO Query

No, you don't need the inner single quotes so just $term = "$term%";

The statement you're running now would try to match 'a%' instead of a%

bindParam will make sure that all string data is automatically properly quoted when given to the SQL statement.


You can use bindValue , suppose you are having a $query = "search string"

$stmt->bindValue(':term', $query.'%'); // this will do like search for "search term XXXXX"

similarly

$stmt->bindValue(':term', '%'.$query.'%');

or

$stmt->bindValue(':term', '%'.$query);