mysql查询当前时间前的操作相关操作

#查询今天:

SELECT * FROM `table_name`  WHERE TO_DAYS(`time_filed`) = TO_DAYS(NOW());

#查询昨天:

SELECT * FROM `table_name`  WHERE   TO_DAYS(NOW()) - TO_DAYS(`time_filed`) =1;

#查询今天之前的内容:

SELECT * FROM `table_name`  WHERE   TO_DAYS(NOW()) - TO_DAYS(`time_filed`) >=1;

#查询 7天

SELECT * FROM `table_name`  WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= DATE(`time_file`);

#查询本月

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

#查询上个月

SELECT * FROM `table_name`   WHERE PERIOD_DIFF( date_format( now( ) , '%Y%m' ), date_format( `time_filed`, '%Y%m' ) )=1 

#查询 本季度

SELECT * FROM `table_name`  WHERE QUARTER(`time_filed`) = QUARTER(NOW());

#查询 上季度
SELECT * FROM table_name WHERE QUARTER(`time_filed`) = QUARTER(DATE_SUB(NOW(),INTERVAL 1 QUARTER))

参考链接:http://blog.sina.com.cn/s/blog_95ee143401016axl.html