Mysql Sort Decimal with alpha Numeric Values

Mysql-Sorting Decimal with Alpha-Numerical Values
I have some decimal alphanumerical values :(Datas from Mysql table)

2mm,
3x4mm,
2.5x5mm,
1.7x6mm,
1.7x9mm,
1.6x5mm,
3mm,
5mm,
3.5x5mm,
3.5x8mm,
10x7mm,

Expeted Answer should be: ASC Order:(below format)

1.6x5mm,
1.7x6mm,
1.7x9mm,
2mm,
2.5x5mm,
3mm,
3x4mm,
3.5x5mm,
3.5x8mm,
5mm,
10x7mm,

Note: x – means alphabet ‘ x ‘.

So I need both decimal and alphanumerical sorting…. Please considered my question.
Thank you,


Source: New Questions

Leave a Reply