mysql 获取昨天数据

SELECT *
FROM logs
WHERE created_at >= DATE_SUB(CURDATE(), INTERVAL 1 DAY)
  AND created_at < CURDATE();

SELECT *
FROM logs
WHERE created_at >= CONCAT(CURDATE() - INTERVAL 1 DAY, ' 00:00:00')
  AND created_at < CONCAT(CURDATE(), ' 00:00:00');

SELECT *
FROM logs
WHERE created_at BETWEEN DATE_SUB(CURDATE(), INTERVAL 1 DAY) AND CURDATE();

SELECT *
FROM logs
WHERE CONVERT_TZ(created_at, @@session.time_zone, '+08:00') >= DATE_SUB(CURDATE(), INTERVAL 1 DAY)
  AND CONVERT_TZ(created_at, @@session.time_zone, '+08:00') < CURDATE();

-- 添加索引
ALTER TABLE logs ADD INDEX idx_created_at (created_at);

-- 分页查询
SELECT *
FROM logs
WHERE created_at >= DATE_SUB(CURDATE(), INTERVAL 1 DAY)
  AND created_at < CURDATE()
LIMIT 10 OFFSET 0;