mysql查询当天、本周、本月的数据

1、mysql查询当天的数据

SELECT * FROM table_name
WHERE date_column >= CURDATE()AND date_column < CURDATE()+ INTERVAL 1 DAY

2、查询本周的数据

SELECT * FROM table_name 
WHERE date_column >= CURDATE() - INTERVAL WEEKDAY(CURDATE()) DAY 
AND date_column < CURDATE() + INTERVAL (7 - WEEKDAY(CURDATE())) DAY;

3、查询最近一周内的数据

SELECT * FROM table_name 
WHERE date_column >= DATE_SUB(CURDATE(), INTERVAL 1 WEEK);

4、查询本月的数据

SELECT * FROM table_name 
WHERE DATE_FORMAT(date_column, '%Y-%m') = DATE_FORMAT(CURDATE(), '%Y-%m');