统计一周
select * from `表名`ct where week(`时间字段`) = week(now()) ORDER BY
我的例子:select * from t_circle_topic ct where week(ct.create_time) = week(now()) ORDER BY ct.create_time DESC;
统计一个月
select * from `表名`where DATE_SUB(CURDATE(), INTERVAL 1 MONTH) <= date(`时间字段`)