title: mysql order by date hardcoded to bad format
body: <p>dates are stored in the database as</p>
  
  <pre><code>    | mm-dd-yy | content | content | content|
      | mm-dd-yy | content | content | content|
      | mm-dd-yy | content | content | content|
      | mm-dd-yy | content | content | content|
  </code></pre>
  
  <p>what syntax would be used to ORDER BY <code>date</code> ASC while taking the year into account?</p>
  
  <p>Edit: there are over 20,000 records stored this way and the application built on the data requires the date to be formatted this way, otherwise i would just change them all.</p>