MYSQL统计一周，一个月的数据

统计一周

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(`时间字段`)