Mysql sorting solution

Mysql sorting 2009-102009-82009-10 + 210021-8 I want to arrange like this. the characters before "-" are sorted in ascending order, after "-", the numbers are arranged in ascending order of 10021-82009-82009-102009-10 + 2, SELECTsubstring (fld1, 1, (instr (fld1, '-mysql)
2009-10
2009-8
2009-10 + 2
10021-8

I want to arrange it like this. the characters before "-" are sorted in ascending order, and the numbers after "-" are sorted in ascending order.
10021-8
2009-8
2009-10
2009-10 + 2

------ Solution --------------------
SELECT substring (fld1, 1 ,(
Instr (fld1, '-')-1)
) AS fld1, substring (fld1 ,(
Instr (fld1, '-') + 1)
) AS fld2
FROM 'table1'
Order by fld1 ASC, fld2 ASC

Select on the outer layer is not acceptable.
In this case, it should be okay if the data volume is large.
------ Solution --------------------
ReferenceI want to arrange it like this. the characters before "-" are sorted in ascending order, and the numbers after "-" are sorted in ascending order.
10021-8
2009-8
2009-10
2009-10 + 2