php mysql如何修改查询时间段

Question

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

如何修改查询时间段？如：查今天早上07:05:00 到明天早上 06:00:00 这段时间的数据，数据库里的是时间戳的形式！

Answer 1

where 字段 between 开始时间 and 结束时间

$sql = "SELECT * FROM jz_data where type='5' and create_time between '早上时间戳' and '明早时间戳' order by number desc LIMIT 100";