In the screenshot below you can see that there columns "Item 1" and "Item 2" have values. Item 2 column does not sort in the proper order as the value 53 is less than 520. How do I get this so that single, double, and triple-digit values sort properly? Item 1 column sorts highest to lowest while Item 2 sorts the results of Item 1 from highest to lowest.



maybe this page can give you some help on sorting in mysql:
https://stackoverflow.com/questions/8557172/mysql-order-by-sorting-alphanumeric-correctly
https://stackoverflow.com/questions/8557172/mysql-order-by-sorting-alphanumeric-correctly
You need to login to be able to post a reply.