a表，时间字段为create_time

查询过去一年的数据

select * from a

where create_time between date_add(date(curdate()), interval -1 year) and date(curdate());

过去一个月

select * from a

where create_time between date_add(date(curdate()), interval -1 month) and date(curdate());