php - Mysql 通配符和数组替换错误

Question

我有以下数据库查询，它正在查找 MySql 表中以某种模式结尾的行。

$res = db_query('SELECT identifier FROM {rules_scheduler} WHERE identifier LIKE %:schid', array(':schid' => '_' . $sch_id));
foreach ($res as $rec) {
    scheduler_delete_schedule($component, $rec->identifier);
}

但这会导致以下错误......

PDOException: SQLSTATE[42000]: 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 '%'_591'' at line 1: SELECT identifier FROM {rules_scheduler} WHERE identifier LIKE %:schid; Array ( [:schid] => _591 ) in _callback_delete_scheduled_notifications()

所以看起来我的 :schid 标记已正确替换为 _591 ，但 % 和下划线之间似乎有一个引号。我一生都无法弄清楚为什么!

Answer 1

我不知道 {rules_scheduler} 应该是什么，所以我将为您提供一个与通配符配合使用的查询字符串:

$query = "SELECT identifier FROM rules_scheduler WHERE identifier LIKE CONCAT('%', :schid)";

$res = db_query($query, [':schid' => '_' . $sch_id]);