title: mysql week from Monday till Sunday
body: <p>i want to group my data by yearweek but the week starts here in sunday.
  how can i group my week from monday till sunday?</p>
  
  <p>Here is my query:</p>
  
  <pre><code>SELECT YEARWEEK(dateStats) k,dateStats udate, COUNT(f_shop) sales
  FROM sal_import WHERE dateStats BETWEEN "2011-08-15" AND "2011-08-21" GROUP BY YEARWEEK(dateStats)
  </code></pre>
  
  <p>The Between has a date from Monday till Sunday and i need just one row at the result.</p>
  
  <p>Thank you very much</p>