title: MYSQL Query with 2 ORDER BYs on the same column
body: <p>I have a Query that I want to return 2 ORDER BYs. When I run the Query itself, it keeps the priority on getting the ABS value. Is there anyway I can get around this so my query returns an organized list where Bananas is DESC from the smallest to the largest.</p>
  
  <p>Query:</p>
  
  <pre><code>SELECT Apples, Bananas 
  FROM TheJungle 
  WHERE Strawberries = 1960 
  ORDER BY ABS(9992-CAST(`Bananas` AS SIGNED)) LIMIT 13
  </code></pre>
  
  <p>I would like my query to return an organized list where Bananas is DESC from the smallest to the largest. Something like: </p>
  
  <pre><code>SELECT Apples, Bananas 
  FROM TheJungle 
  WHERE Strawberries = 1960 
  ORDER BY ABS(9992-CAST(`Bananas` AS SIGNED)), Bananas DESC LIMIT 13
  </code></pre>
  
  <p>I cant post pictures of what my current query is returning since my rep isn't high enough.</p>