title: SQL order string as number
body: <p>I have numbers saved as <code>VARCHAR</code> to a MySQL database. I can not make them <code>INT</code> due to some other depending circumstances. </p>
  
  <p>It is taking them as character not as number while sorting.</p>
  
  <p>In database I have </p>
  
  <pre><code>1 2 3 4 5 6 7 8 9 10...
  </code></pre>
  
  <p>On my page it shows ordered list like this:</p>
  
  <pre><code>1 10 2 3 4 5 6 7 8 9
  </code></pre>
  
  <p>How can I make it appear ordered by numbers ascending?</p>