php mysql如何修改查询时间段

Question

$sql = "SELECT * FROM jz_data where type='5' order by number desc LIMIT 100";

如何修改查询时间段？如：查2021-12-04 07:05:00 到2021-12-05 06:00:00 这段时间的数据

Answer 1

SELECT * FROM jz_data where type='5' and (日期字段) between 2021-12-04 07:05:00 and 2021-12-05 06:00:00 order by number desc LIMIT 100

前提是你的数据库日期字段是2021-12-04 07:05:00形式的