php - 在 DATE 比较时出现 MYSQL 错误

Question

我正在尝试比较我的 DATE 列，但收到以下错误。

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 'events.sched_expired < '2015-11-25' THEN '0' ' at line 4

这是我的qhery:

UPDATE events SET events.scheduled = ( CASE sched_exp_type WHEN 'counter' and events.sched_counter <= '0' THEN '0' WHEN 'date' events.sched_expired < '2015-11-25' THEN '0' ELSE (events.scheduled) END )

这是我的 php 代码:

 $c_date = date("Y-m-d");
echo $c_date."<br/>";
$update_sched_column = "UPDATE events SET  events.scheduled = (
CASE sched_exp_type
WHEN 'counter' and events.sched_counter <= '0' THEN '0'
WHEN 'date' events.sched_expired < '$c_date' THEN '0'
ELSE (events.scheduled)
END
)";

Answer 1

您的 case 语句无法按您期望的那样工作，并且还存在语法错误。请尝试以下操作:

 $update_sched_column ="
     UPDATE events
     SET  events.scheduled = (
     CASE WHEN sched_exp_type = 'counter' and events.sched_counter <= '0' THEN '0'
          WHEN sched_exp_type = 'date' and events.sched_expired < '$c_date' THEN '0'
          ELSE (events.scheduled)
     END)";