Codes here !
2 posts • Page 1 of 1
Separate the numerical and alpha part into two columns, then sort the numerical followed by alpha and it should work OK
I don't understand why MySQL doesn't sort it accordingly, even if it's got letters after the numbers. It knows how to sort letters. Are you sure there's not a problem in your query or something?