select * from 表名
where
DATE_FORMAT(表名.日期字段名,’%Y-%m-%d’) = DATE_FORMAT(NOW(), ‘%Y-%m-%d’)
09-21
9995
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
07-12
1210
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
select * from 表名
where
DATE_FORMAT(表名.日期字段名,’%Y-%m-%d’) = DATE_FORMAT(NOW(), ‘%Y-%m-%d’)