mysql查询每一天某个时间段的所有记录(例:9:00:00到21:00:00):
SELECT * FROM 表名
WHERE DATE_FORMAT(create_time,'%H:%i:%S')>='09:00:00'
and DATE_FORMAT(create_time,'%H:%i:%S')<='21:00:00'
ORDER BY 排序字段 ASC;