MySQL-查询某天某个时间段的数据

查询每天某个时间段的数据

早高峰

SELECT COUNT(*) AS count FROM table WHERE hour(created_at) BETWEEN 07 and 09

如果是凌晨需要转换

凌晨

SELECT COUNT(*) AS count FROM table WHERE hour(created_at) >=22 or hour(created_at)<= 6