MySQL：按周计算。(MySQL: counts by week.)

MySQL：按周计算。(MySQL: counts by week.)

我想按周计算一系列计数。 我知道使用week（）函数返回一周的数字，但我喜欢这样的东西：

Week count(*) Jan 1 - Jan 7 30 Jan 8 - 14 50 and so on...

有没有办法做到这一点？ 非常感谢你。

I would like to group a series of counts but by week. I know that using the week() function returns a number for the week, but i'd like something like this:

Week count(*) Jan 1 - Jan 7 30 Jan 8 - 14 50 and so on...

Is there a way to do this? Thank you very much.

最满意答案

select concat(cast(DATE_ADD(yourdate, INTERVAL(1-DAYOFWEEK(yourdate)) DAY) as char), ' - ', cast(DATE_ADD(yourdate, INTERVAL(7-DAYOFWEEK(yourdate)) DAY) as char)) as period, count(*) from tablename group by week(yourdate) select concat(cast(DATE_ADD(yourdate, INTERVAL(1-DAYOFWEEK(yourdate)) DAY) as char), ' - ', cast(DATE_ADD(yourdate, INTERVAL(7-DAYOFWEEK(yourdate)) DAY) as char)) as period, count(*) from tablename group by week(yourdate)