Order by alphanumeric in mysql <p>Can you help me? </p> <p>my query is </p> <pre><code>SELECT num FROM sortnum ORDER BY lpad(num, 10, 0) </code></pre> <p>result of this query is not good here is the result </p> <pre><code>1 2 3 4 5 6 7 8 9 10 11 12 13 14 1a 2a 2b A1 A2 A3 A4 B1 A10 A11 B10 </code></pre> <p>What is the best query for this type of data i want number first, then data starting with a , then with b </p> <p>i want result like </p> <pre><code>1 1a 2 2a 2b 3 4 5 6 7 8 9 10 11 12 13 14 A1 A2 A3 A4 A10 A11 B1 B10 </code></pre> <p>Thanks in advance</p>