我需要提取从现在到当前日期结束的最后一百个呼叫
ejm:
select * from call where create_at between >= yyyy-mm-dd 00:00:00 and <= yyyy-mm-dd 23:59:59 limit 100
我如何提取这个范围之间的数据?
当前日期,是指今天吗?
SELECT * from call
WHERE create_at BETWEEN 'today' AND 'tomorrow'
LIMIT 100
如前所述,您可能还想对它们进行排序,逻辑上向后排序将得到最后100
SELECT * from call
WHERE create_at BETWEEN 'today' AND 'tomorrow'
ORDER BY create_at desc
LIMIT 100
你还提到了"从现在开始",所以如果你不想要已经过去的时间,你可以使用(带顺序或不带顺序)
SELECT * from call
WHERE create_at BETWEEN now() AND 'tomorrow'
LIMIT 100