2.04 hybrid sorting of alphanumeric numbers

Problem: Existing letters and numbers mixed with data that you want to sort by numbers or character parts. Consider this view:

CreateView VAsSelect Concat (ename, ", Deptno) from EMP;Mysql> select * from V;
+---------------------------+
| Concat (ename, ", Deptno) |
+---------------------------+
| SMITH 20 |
| ALLEN 30 |
| WARD 30 |
| JONES 20 |
| MARTIN 30 |
| BLAKE 30 |
| CLARK 10 |
| SCOTT 20 |
| KING 10 |
| TURNER 30 |
| ADAMS 20 |
| JAMES 30 |
| FORD 20 |
| MILLER 10 |
+---------------------------+
Rows in Set (0.00 sec)


Since MySQL does not support the translate function, there is no solution to this problem.

2.04 hybrid sorting of alphanumeric numbers