Alphabetical SQL order without leading zeros for numbers less than 10

Question

Is it possible to alphabetize in mySQL as follows:

A1
A2
A3
A5
A10
A11
A20
A23
A24

Unfortunately, the order I get is ordered as shown below. Please note that any number up to A10 is not grouped together?

A1
A10
A11
A12
A2 <A2
A20
A23
A24
A3 <A3
A5 <A5

: - , A01, . , , , . , - , .

Answer 1

, . , .

...
ORDER BY SUBSTR(postalcode,2)+0

Answer 2

UDF, varchar . ORDER BY .

, - ASCII A ( ) * 100 + varchar.

Answer 3

, , . , , : NC27605. zip_code , - . , zip_code.

; .

Answer 4

.

, . , ASC DESC .

MySQL, New Riders, 2000, Paul DuBois ( )

MySQL 3.23.2, . , `ORDER BY RAND()

- , , varchar , ORDER BY? ?

, , .