---- 查询未来10天内的数据 --------
SELECT * FROM table WHERE expire_time<= DATE_ADD(NOW(), INTERVAL 10 DAY);
---- 查询还有10天即将到期的数据 --------
SELECT * FROM table WHERE expire_time between NOW() and DATE_ADD(NOW(), INTERVAL 10 DAY);
---- 查询当天到期的数据 --------
SELECT * from table WHERE curdate() = DATE_ADD(expire_time , interval 0 DAY);
SELECT * from table WHERE TO_DAYS(expire_time ) = TO_DAYS(NOW());
---- 查询昨天到期的数据 --------
SELECT * from table WHERE TO_DAYS(curdate()) - TO_DAYS(date_format(expire_time,'%Y-%m-%d')) = 1";
---- 查询今天到期的数据 --------
SELECT * FROM table WHERE date_format(expire_time,'%Y-%m-%d') = curdate();