我试图在php PDO中执行查询，但是执行方法导致HTTP ERROR 500

$query = "select * from job_t where title like '%:title%' and salary>=:salary";
$st = $conn->prepare($query);
$st->bindParam(":title", $_GET['title']);
$st->bindParam(":salary", $_GET['salary']);
$st->execute();

预期的输出是job_t的表，但实际结果是http错误500

分析解答

这个'%:title%'应该不起作用..所以

尝试使用concat构建适当的like子句

$query = "select * from job_t 
  where title like concat('%', :title, '%')  and salary>=:salary";