SELECT * FROM 表名 where 时间字段 BETWEEN 开始时间 and 结束时间;例如：SELECT * FROM table where time BETWEEN '2018-05-20' and '2018-05-21' ;