title: MySQL Sort By 2 Columns
body: <p>I have a table which holds information on television programs and I want to order it by Seasons and then by episodes. Here's a basic view of what I have:</p>
  
  <pre><code>+---+--------+---------+
  |id | Season | Episode |
  +---+--------+---------+
  | 1 |    1   |    1    |
  +---+--------+---------+
  | 1 |    1   |    2    |
  +---+--------+---------+
  | 1 |    2   |    1    |
  +---+--------+---------+
  | 1 |    2   |    3    |
  +---+--------+---------+
  </code></pre>
  
  <p>So I select what I need and order by Season. But there's going to be a lot between seasons so I need to sort episodes too, but without it affecting seasons.</p>