How to ORDER BY a field consisting of digits following by alphabets in MySQL?

Question

How to ORDER BY a field consisting of digits following by alphabets, such as 10s, in MySQL? The desired order is:

• digits, e.g., 10
• digits+alphabets, e.g., 10s

For instance,

# Original data:
1
10
105
109
10s

# Desired results
1
10
10s
105
109

Answer 1

One possible approach:

ORDER BY CAST(alphanum AS UNSIGNED), alphanum

... or, slightly more concise:

ORDER BY alphanum + 0, alphanum

Demo.

Answer 2

Try this:

SELECT values FROM Table ORDER BY CAST(values AS UNSIGNED), values;