How to do correct sorting in MySQL?

Question

MySQL

There is a table of goods which has an article number field.
Example

a-1
a-2
a-11
b-1
letters-1

I need to sort them both alphabetically and ascending.
Now it's happening like this

a-1
a-11
a-12
a-2

but I would like

a-1
a-2
a-11
a-12

Tell me if there is any easy solution without crutches that come to my mind.
Thanks in advance.

Answer 1

SELECT * FROM `table` ORDER BY SUBSTRING(`field`, 1, 1), LENGTH(`field`), `field`;

Answer 2

www.copterlabs.com/natural-sorting-in-mysql
I think this article should partially help, but it is not a panacea.

Answer 3

It would be logical to divide the column by 2.

Answer 4

Yes, it only works partially. If I had a- everywhere, it would help.
And so first all the letters in Alvatit with numbers up to 10 go, and then the rest.