title: MySQL multiple column asc order
body: <p>I am trying to run this query in ascending order:</p>
  
  <pre><code>SELECT title,project_index 
  FROM projectdetail  
  WHERE project_index BETWEEN 1 AND 6 
  ORDER BY title, project_index ASC;
  </code></pre>
  
  <p>I need two columns in ascending order, but the above query returns results with only one column in <code>ASC</code> order.</p>