php - 在 DELETE 语句中指定 'older than'

Question

我有一个查询，我想用它来删除“已查看”列日期时间值超过 24 小时的数据行。我怎样才能用一个查询来做到这一点？是否可以？

这是我目前所拥有的:

$delete_expired_notifications_query= "DELETE FROM notifications WHERE user_id= 
'".$u_id."' AND viewed (some code that says older than 24hrs)";
    mysqli_query($connect, $delete_expired_notifications_query);

Answer 1

假设 viewed 是一个 MySQL 时间类型(它应该是):

... AND viewed < NOW() - INTERVAL 24 HOUR