Order By Name not working as intended - MySQL

Question

I have the following simple query:

SELECT * FROM grade order by GRADENAME

It outputs:

enter image description here

This is a problem mostly on the user experience part, Since he received the grades on the <select></select> element as the list above shows. Is there a way I can order them to show starting from 1A all the way to 11D? Is there a possible way to do it?

EDIT

Applying SELECT * FROM grade order by BIN(GRADENAME);

results in:

enter image description here

score 1 · Accepted Answer · answered Jul 07 '14 at 09:18

1

Try this

SELECT * FROM grade order by BIN(GRADENAME);

answered Jul 07 '14 at 09:18

Sadikhasan

18,365
21
80
122

Works only for the first 4 rows. Then it starts ordering them in a weird way. What does that do exactly? – CodeTrooper Jul 07 '14 at 09:21
Check reference link http://stackoverflow.com/questions/8557172/mysql-order-by-sorting-alphanumeric-correctly – Sadikhasan Jul 07 '14 at 09:24
1

May be this link is solved your issue http://bytes.com/topic/mysql/answers/881790-mysql-natural-sort – Sadikhasan Jul 07 '14 at 09:31

Vignesh Kumar A · Answer 2 · 2014-07-07T09:35:23.353

1

May be something like this

SELECT * FROM grade 
Order By Cast(SubString(GRADENAME,1,Length(GRADENAME) -1 As Int),Right(GRADENAME,1)

Or

SELECT * FROM grade 
Order By lpad(GRADENAME, 10, 0)

edited Jul 07 '14 at 09:35

answered Jul 07 '14 at 09:30

Vignesh Kumar A

27,863
13
63
115

This does work as well. But it has more code than `SELECT * FROM grade order by lpad(GRADENAME, 10, 0)`. I will stay with the one I found. Thanks for your answer though. – CodeTrooper Jul 07 '14 at 09:33

score 0 · Answer 3 · edited Jul 08 '14 at 06:11

0

Try this

SELECT GRADEID, 
       GRADENAME 
FROM   GRADE 
GROUP  BY GRADENAME 
ORDER  BY 2;

edited Jul 08 '14 at 06:11

Gidil

4,137
2
34
50

answered Jul 07 '14 at 12:42

RSB

359
5
10

Order By Name not working as intended - MySQL

EDIT

3 Answers3