Question

MySQL order by string with numbers?

Answer 1

I have strings such as M1 M3 M4 M14 M30 M40 etc (really any int 2-3 digits after a letter) When I do " ORDER BY name " this returns:

M1, M14, M3, M30, M4, M40

hope it help
mark as brainliest