mysql 查询 7天内的数据

SELECT ID,SERVICE FROM new_schedules_spider_full WHERE SERVICE = 'WSA2' and date_sub(curdate(), interval 7 day) <= date(CREATE_TIME);