group by date help

[shawjames]

Hello,
I currently use this query to see a list of my order counts:

SELECT date, count(date) FROM orders WHERE 1 group by to_days(date)

I want to do the same thing, but instead of grouping by day, I want to group by week and month.

Any ideas of how I can do this?

Thanks!

[hthighway]

for grouping by week

GROUP BY week(date)

for grouping by month

GROUP BY month(date)

Reference: http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html