title: ORDER BY alphabet first then follow by number
body: <p>I looking for some tweak in mysql ordering , I normally select record from table and then order the record by Name(varchar) ASC <strong>but the number is always come first</strong></p>
  
  <p>here some example of my question (<em>note. mysql sort the record with 0-9 first</em>)</p>
  
  <pre><code>SELECT name FROM list ORDER BY name ASC
  record returned:
  1 star
  2 star
  9 slice
  Ape
  Age
  Beg
  Bell
  Fish
  Zoo
  </code></pre>
  
  <p><strong>What i want is the alphabet order come first then follow by number</strong></p>
  
  <p>Desired output</p>
  
  <pre><code>Ape
  Age
  Beg
  Bell
  Fish
  Zoo
  1 star
  2 star
  9 slice
  </code></pre>