title: Order by numeric values in SQL ascending
body: <p>I'm trying to get this output.</p>
  
  <pre><code>MDT 1
  MDT 2
  MDT 3
  MDT 11
  MDT 44
  </code></pre>
  
  <p>but, The values are ordered alphabetically, so 123 comes before 2.</p>
  
  <p>example :</p>
  
  <pre><code>MDT 1
  MDT 11
  MDT 156
  MDT 2
  MDT 3
  MDT 303
  MDT 44
  </code></pre>
  
  <p>and so on.</p>
  
  <p>I'm use this code, but it seem didn't work.</p>
  
  <pre><code>SELECT * FROM file ORDER BY ABS(ID) ASC
  </code></pre>
  
  <p>How can I solve this?</p>