I'm trying to get this output.
- MDT 1
- MDT 2
- MDT 3
- MDT 11
- MDT 44
MDT 1 MDT 2 MDT 3 MDT 11 MDT 44 but, The values are ordered alphabetically, so 123 comes before 2.
example :
- MDT 1
- MDT 11
- MDT 156
- MDT 2
- MDT 3
- MDT 303
- MDT 44
MDT 1 MDT 11 MDT 156 MDT 2 MDT 3 MDT 303 MDT 44 and so on.
imI'm use this code, but it seem didn't work.
SELECT * FROM file ORDER BY ABS(ID) ASC howHow can iI solve this? thank you.