mysql - 选择 * WHERE status <> 'deleted' 或 status <> 'completed' AND update_datetime < unix_timestamp(now() - 间隔 7 天)

Question

如果 update_datetime 列早于 7 天(MySQL 版本 2013-04-11 11:22: 44).

这是我无力且失败的尝试:

WHERE
    status <> 'deleted'
 OR status <> 'completed'
AND update_datetime < unix_timestamp( now() - interval 7 day )

Answer 1

WHERE
    status <> 'deleted'
AND (
        (update_datetime < unix_timestamp( now() - interval 7 day ) AND status = 'completed')
    OR  (update_datetime >= unix_timestamp( now() - interval 7 day ))
)

如果 update_datetime 是 DATETIME 列，请改用它:

WHERE
    status <> 'deleted'
AND (
        (update_datetime < DATE_SUB(NOW(), INTERVAL 7 day) AND status = 'completed')
    OR  (update_datetime >= DATE_SUB(NOW(), INTERVAL 7 day))
)