title: ORDER BY complex
body: <p>I've a mysql_query: <code>select * from table ORDER BY v1, v2 ASC</code></p>
  
  <p>Can be made a query to sort <code>v1</code>, <code>v2</code> as below ?</p>
  
  <pre><code>+---------------+-----------------------+------+-----+
  | id            | name                  | v1   | v2  | 
  +---------------+-----------------------+------+-----+
  | 1             | a                     | 1    |  A  |
  | 2             | a                     | 2    |  B  |
  | 3             | a                     | 3    |  C  |
  | 4             | a                     | 1    |  A  |
  | 5             | a                     | 2    |  B  |
  | 6             | a                     | 3    |  C  |
  | 7             | a                     | 1    |  A  |
  | 7             | a                     | 2    |  B  |
  | 7             | a                     | 3    |  C  |
  +---------------+-----------------------+------+-----+
  </code></pre>
  
  <p><a href="http://sqlfiddle.com/#!2/54285/6/0" rel="nofollow">SQL fiddle</a></p>