php - SELECT * FROM Table WHERE Column LIKE %?%

Question

基于这里的信息MySQL query String contains尝试使用 ?

创建 pdo 查询

实验如下

SELECT * FROM Table WHERE Column LIKE %?%

SELECT * FROM Table WHERE Column LIKE ?%

SELECT * FROM Table WHERE Column LIKE %?

没有任何作用。获取错误

Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%...

尝试使用 SELECT * FROM Table WHERE Column LIKE ? 但这不适用于 contains

目的是获取查询SELECT * FROM Table WHERE Column contains ?

什么是位置占位符 (?) 的正确 pdo contains 语句？

Answer 1

尝试通过 PHP 连接字符串中的值，

$value = "valueHere";
$passThis = "%" . $value . "%";
// other pdo codes...
$stmt = $dbh->prepare("SELECT * FROM Table WHERE Column LIKE ?");
$stmt->bindParam(1, $passThis);
// other pdo codes...