mysql查询近几天数据发现个很简便的写法😀😃😄😁😆
今天
SELECT COUNT(*)count FROM special_work_list WHERE start_date >= DATE_SUB( NOW( ), INTERVAL 1 DAY )
近7天
SELECT COUNT(*)count FROM special_work_list WHERE start_date >= DATE_SUB( NOW( ), INTERVAL 7 DAY )
近30天
SELECT COUNT(*)count FROM special_work_list WHERE start_date >= DATE_SUB( NOW( ), INTERVAL 30 DAY )