title: MySQL sort varchar column numeric, numbers first
body: <p>I've got a varchar column that I want to sort numeric, which works great when using this trick: <a href="https://stackoverflow.com/a/5418033/1005334">https://stackoverflow.com/a/5418033/1005334</a> (in short: <code>...ORDER BY Result * 1</code>).</p>
  
  <p>However, the table concerned contains results. So something like this occurs:</p>
  
  <pre><code>Result
  ------
  DNS
  DNF
  1
  2
  3
  </code></pre>
  
  <p>The numbers are correctly ordered, but the <code>DNF</code> comes above the numbers when sorting like this. What I'd like is to have the numeric sort, but with non-numbers sorted alphabetically <strong>below</strong> the numbers. Like so:</p>
  
  <pre><code>Result
  ------
  1
  2
  3
  DNF
  DNS
  </code></pre>
  
  <p>In what way can I modify the query (preferably only the <code>ORDER BY</code> clause) to get this result?</p>