How to sort two varchar columns order by

Asked Mar 18 '21 at 09:05

Active Mar 18 '21 at 09:10

Viewed 17 times

By default if you write order by it is considered as ascending order and if you want like highest to lowest use as: order by desc. But my question is how to sort two things like I have name and class (VarChar) both how can i sort them both? Please help. I am using MySQL query: select name,class from student order by name asc, class asc; but it's not showing what I want. Data is like: name: Mike class: Four

select name,class from student order by name asc, class asc;

edited Mar 18 '21 at 09:10

asked Mar 18 '21 at 09:05

Ali Asadullah Shah

Show us the data ordered in your wanted way. – jarlh Mar 18 '21 at 09:08
And what do you expect? You cannot sort by both in the same weight because then you would have wrong results. So its sorting first for name and then for class. – Thallius Mar 18 '21 at 09:09
then you should store class as number `4` not `Four` – Devsi Odedra Mar 18 '21 at 09:09
1

@DevsiOdedra Good point. Perhaps that what he wants – Thallius Mar 18 '21 at 09:10
I was practicing mysql I am not sure what results to accept but as far as I understand I think name should be sorted and class also like I've class as One Two and Three it must come as One, Two, Three so as for names like Zoya, Asad and John should print as Asad, John and Zoya @DevsiOdedra – Ali Asadullah Shah Mar 18 '21 at 09:12
@ClausBönnhoff help please – Ali Asadullah Shah Mar 18 '21 at 09:15
1

@shadow, seems like the question here is how to sort numbers written as words as numbers, not alphabetically. – jarlh Mar 18 '21 at 09:18
1

As Devise mentioned, You cannot sort on alphabetical numbers. Four is sorted before one because F is before O. So you must enter your classes as integers values to be able to sort correct – Thallius Mar 18 '21 at 09:18
@jarlh you are right! – Ali Asadullah Shah Mar 18 '21 at 09:27
1

@AliAsadullahShah, or have a mapping table storing numbers both as digits and words, which you JOIN. – jarlh Mar 18 '21 at 10:01

How to sort two varchar columns order by

0 Answers0