title: MySQL grouping by week, based on a date column?
body: <p>I have a table with a date column and I would like to try and group by, using a week as a time reference in order to count how many rows occured per week. I have done this for days, using GROUP BY Date(<code>Date_Column</code>) but i'm unsure how to do this by week?</p>
  
  <p>Thanks</p>