昨日/今日 TO_DAYS(time) = TO_DAYS(NOW())-1 //去掉-1为今日 本周 YEARWEEK(date_format(time,'%Y-%m-%d')) = YEARWEEK(now()) //同理-1为上周 本月 DATE_FORMAT( time, '%Y%m' ) = DATE_FORMAT( CURDATE( ) , '%Y%m' )