Mysql alphanumeric sorting

In mysql, the following fields are sorted by numbers and letters: & nbsp; id1a2b3c, numbers are sorted by numbers. one solution is selectIdfromaorderby mysql.
Table a has the following fields:
Id 1 a 2 B 3 c
After sorting
Id a B c 1 2 3
That is to say, the characters are sorted by characters, and the numbers are sorted by numbers.
Read a solution
Select Id from a order by (case when REGEXP_LIKE (trim (Id), '^ [0-9] + $') then ascii (Id) + 74 else ascii (Id) end)
Result mysql cannot recognize REGEXP_LIKE.

------ Solution --------------------

SQL code

Select 'id' as chunion select '1' union select 'A' union select '3' union select 'C' union select '2' union select 'B' order by length (ch) desc, ch + 0 = 0 desc, ch