Sorting a textbox as a number and as a string at the same time?

Question

MySQL

Hello! I'm displaying data from a table in a GridView. There is a field "Number" - text type. Can you please tell me how to sort this field in the Mysql database at the same time as a number and a string. For example:
1, 2, Field, Number, 10, 15
And get after sorting
1, 2, 10, 15, Number, Field

Answer 1

There is no natural sort in SQL, only two options ASC / DESC
SELECT * FROM table ORDER BY value ASC

Answer 2

If all numeric values ​​are non-negative integers, then

ORDER BY IF(`val` REGEXP('^[0-9]+$'), LENGTH(`val`), 100), `val`