title: Order a MySQL table by two columns
body: <p>How do I sort a MySQL table by two columns?</p>
  <p>What I want are articles sorted by highest ratings first, then most recent date.  As an example, this would be a sample output (left # is the rating, then the article title, then the article date)</p>
  <pre>
  +================+=============================+==============+
  | article_rating | article                     | article_time |
  +================+=============================+==============+
  | 50             | This article rocks          | Feb 4, 2009  |
  +----------------+-----------------------------+--------------+
  | 35             | This article is pretty good | Feb 1, 2009  |
  +----------------+-----------------------------+--------------+
  | 5              | This Article isn't so hot   | Jan 25, 2009 |
  +================+=============================+==============+
  </pre>
  <p>The relevant SQL I'm using is:</p>
  <pre><code>ORDER BY article_rating, article_time DESC
  </code></pre>
  <p>I can sort by one or the other, but not both.</p>