title: Get mySQL MONTH() to use leading zeros?
body: <p>How do I specify to mySQL's MONTH() function to return '08' instead of 8 in this query?</p>
  
  <p>I'd like the sort to work datewise.  Currently getting results for date like</p>
  
  <pre><code>2006-9
  2007-1
  2007-10
  2007-11
  </code></pre>
  
  <p>current query:</p>
  
  <pre><code>SELECT COUNT(*), CONCAT(YEAR(`datetime_added`), '-', MONTH(`datetime_added`)) as date FROM `person` WHERE (email = '' OR email IS NULL) 
  GROUP BY date 
  ORDER BY date ASC
  </code></pre>