mysql在两个时间范围内

-- 确保时间字段是正确的日期时间格式
SELECT * FROM table_name WHERE start_time >= '2023-01-01 00:00:00' AND end_time <= '2023-12-31 23:59:59';

-- 考虑时区问题
SELECT * FROM table_name WHERE CONVERT_TZ(start_time, '+00:00', @@session.time_zone) >= '2023-01-01 00:00:00' AND CONVERT_TZ(end_time, '+00:00', @@session.time_zone) <= '2023-12-31 23:59:59';

-- 为时间字段创建索引
CREATE INDEX idx_start_time ON table_name(start_time);
CREATE INDEX idx_end_time ON table_name(end_time);

-- 分页查询以减少单次查询的数据量
SELECT * FROM table_name WHERE start_time >= '2023-01-01 00:00:00' AND end_time <= '2023-12-31 23:59:59' LIMIT 100 OFFSET 0;