试试这个
select * from `table` where `yourfield` >= DATE_SUB(CURDATE(), INTERVAL 3 MONTH)
对于天，年份请参见下面的示例。
DATE_SUB(CURDATE(), INTERVAL 15 DAY) DATE_SUB(CURDATE(), INTERVAL 1 YEAR)
对于Anand，查询
BETWEEN DATE_SUB( CURDATE( ) ,INTERVAL 6 MonTH ) AND DATE_SUB( CURDATE() ,INTERVAL 3 MonTH ) /* For Getting records between last 6 month to last 3 month
