SELECT * FROM tableName
where inputtime>DATE_SUB(CURDATE(), INTERVAL 1 WEEK) ///查询一周
where inputtime>DATE_SUB(CURDATE(), INTERVAL 1 MONTH) //查询一个月
where inputtime>DATE_SUB(CURDATE(), INTERVAL 1 YEAR) //查询一年
SELECT * FROM tableName
where inputtime>DATE_SUB(CURDATE(), INTERVAL 1 WEEK) ///查询一周
where inputtime>DATE_SUB(CURDATE(), INTERVAL 1 MONTH) //查询一个月
where inputtime>DATE_SUB(CURDATE(), INTERVAL 1 YEAR) //查询一年