title: Mysql order number / character combined
body: <p>I have a SQL table with in a product-name field with the following values:</p>
  
  <pre><code>10b
   9b
   8b
   7b
   6b
   5b
   4b
   3b
   2b
   1b
  </code></pre>
  
  <p>These needs to be ordered from 1 to 10, but for some reason when i select with the following order: <code>ORDER BY title ASC</code>, then i get:</p>
  
  <pre><code>10b
  1b
  2b
  3b
  4b
  </code></pre>
  
  <p>etc.. </p>
  
  <p>But that 10 needs to be after the 9, not before the 1, how is this possible?</p>
  
  <p>Thank you,
  Kind regards</p>