Sorting results

  • Thread starter Thread starter Anonymous
  • Start date Start date
A

Anonymous

Guest
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?
 
Back
Top