mysql数据库中如何查询日期在两个时间之间的关系

select * from banner where addDate between '2017-06-04' and '2017-06-06';