How to return ASC properly in query

Question

I've got a set of rows in a database that have counts for something specific. When I do my query:

SELECT * FROM table ORDER BY field ASC LIMIT 1

The results I get are incorrect, because it sorts based on the first number apparently.

So the results that are supposed to be:

End up being:

How can I adjust my query so that the field is returned in the proper order? I'm not sure how to word it to search to get the proper answer.

Make sure it is int or a number depending upon your db because the kind of data you have above needs to be in a column of type int — LearningPhase, Apr 27 '16 at 21:40

score 1 · Answer 1 · answered Apr 27 '16 at 21:43

1

There's a trick I learned long time ago that works on even strings of alphabet as well which is.

SELECT * FROM table 
ORDER BY LENGTH(field) ASC, field ASC

learn this trick and you're now a master of ORDER BY :D

answered Apr 27 '16 at 21:43

Tin Tran

1 Answers1