mysql - 如何在 mysql 中的日期时间字段上模拟 LAST()

Question

我想要获取过去 15 天内未订购的客户的列表。

我正在使用查询

SELECT u.name, u.primary_phone 
FROM orders o 
    INNER JOIN user u ON o.user_id = u.id 
WHERE DATE(o.created_at) <= 'date set to 15 days back';

我想使用LAST(o.created_at)，但mysql不允许这样做

Answer 1

要从当前日期减去 15 天，您可以这样做

SELECT u.name ,u.primary_phone 
from orders o 
inner join user u on o.user_id = u.id 
where DATE(o.created_at) <= curdate() - interval 15 day

如果您只想获取过去 5 天内未订购的用户

SELECT u.name, u.primary_phone 
from user u 
left join orders o on o.user_id = u.id 
group by u.name, u.primary_phone 
having sum(DATE(o.created_at) >= curdate() - interval 15 day) = 0