PDO模糊搜索

$sql = "select * from table where name like '%?%'";

$db->query($sql, $name);

报错，加转义字符也不好使。

解决方法：

$sql = "select * from table where name like ?";

$name = "%".$name."%";

$db->query($sql, $name);