使用PDO和MySql一样使用%%

Question

I failed with this. Despite all the answers here, I just cannot get this right. How do I bind a search term when using like in mysql with php's pdo?

$searchTerm = 'kfc';
$stmt = $conn->prepare("select name from table where name like CONCAT('%',:searchTerm,'%')");
$stmt->bindParam(':searchTerm', $searchTerm);

or 

$searchTerm = 'kfc';
$stmt = $conn->prepare("select name from table where name like %:searchTerm%");
$stmt->bindParam(':searchTerm', $searchTerm);

Neither will work for me. How do I get this correct?

Answer 1

You're missing the LIKE clause in both the queries. bindParam will automatically take care of all the quoting, so you don't need to add single-quotes around the search term.

This should work:

$searchTerm = 'kfc%';
$stmt = $conn->prepare("select name from table where name LIKE :searchTerm");
$stmt->bindParam(':searchTerm', $searchTerm);