title: Sort numbers After letters in ORDER BY
body: <p>Hello i am trying to order by in mysql by sorting </p>
  
  <ul>
  <li>Special characters</li>
  <li>Letters</li>
  <li>then Numbers</li>
  </ul>
  
  <p>it seems like mysql sorts by</p>
  
  <ul>
  <li>Special Characters</li>
  <li>Numbers</li>
  <li>then Letters</li>
  </ul>
  
  <p>See below</p>
  
  <pre><code>select distinct uag_linecode from part order by uag_linecode;
  
  | A-1          |
  | A/C          |
  | A1S          |  out of place
  | ABP          |
  | ABS          |
  | ACI          |
  | ADM          |
  | ADR          |
  | BAS          |
  </code></pre>
  
  <p>This is what i want:</p>
  
  <pre><code>A-1 
  A/C
  ABR
  ABS
  ACI
  ADM
  ADR 
  A1S correct spot
  BAS
  </code></pre>
  
  <p>If anyone can help me out i would be eternally grateful.</p>
  
  <p>All the line codes are always 3 characters long.</p>