title: MySQL sorting multiple rows
body: <p>I want to sort on <code>strProjectName</code> and <code>strJobName</code>, <strong>but</strong> I want to prioritize <code>strProjectName</code>. Using the regular order by method: <code>ORDER BY strProjectName, strJobName ASC</code> does work, but not when sorting <code>DESC</code>, due to the fact it will sort on <code>strJobName</code> instead.</p>
  
  <p>TL;DR: I want to sort first on <code>strProjectName</code> and <strong>then</strong> on <code>strJobName</code>. (And yes, there are more fields).</p>