title: Format date in MySQL to return MonthName, Year
body: <p>I have rows in a table that I need to order by date. Easy enough, use the <code>date</code> datatype to store them, <code>ORDER BY</code> date blah blah.</p>
  
  <p>However, I'm trying to get these rows, and easily convert the date to <code>MonthName, Year</code></p>
  
  <p>If I had stored a row's date as <code>2011-11-16</code>, I would want to extract this (using PHP) and print out:</p>
  
  <pre><code> November, 2011
  </code></pre>