Get result of select output in proper order

Question

I have the following mysql statement

SELECT login, personal_email 
FROM users 
WHERE personal_email in ('cc', 'bb', 'dd', 'aa')

I want the output in the following order.

+-------------------------------------+-------------------------------+
| login                               | personal_email                |
+-------------------------------------+-------------------------------+
   xx                                     cc
   yy                                     bb
   zz                                     dd
   ll                                     aa

But I am getting output in random order, like below.

+-------------------------------------+-------------------------------+
| login                               | personal_email                |
+-------------------------------------+-------------------------------
   ll                                     aa
   zz                                     dd
   xx                                     cc
   yy                                     bb

How do I get the results in proper order.

Use an `ORDER BY personal_email` clause at the end of your `select` statement. — Carsten Massmann, Jul 03 '15 at 10:17
If it is based on the order inside `in`, then its not possible. — Ullas, Jul 03 '15 at 10:19
Well, the order suggested by OP seems to be simply alphabetical ... — Carsten Massmann, Jul 03 '15 at 10:20

score 1 · Answer 1 · edited Jul 03 '15 at 10:30

1

If it is alphabetical order that you want, you might want to have a look at ORDER BY clause. It will sort your results according to the alphabetical (or reverse alphabetical, depending on ASC or DSC/DESC).

Try this

ORDER BY personal_email

edited Jul 03 '15 at 10:30

Kaushik

2,072
1
23
31

answered Jul 03 '15 at 10:24

pri

1,521
2
13
26

vivekpansara · Answer 2 · 2015-07-03T14:37:05.440

1

You can sort alphabetical using order by clause. Try below query:

select login, personal_email
from users
where personal_email in ('aa', 'bb', 'cc', 'dd')
order by login

edited Jul 03 '15 at 14:37

answered Jul 03 '15 at 10:28

vivekpansara

895
1
6
14

Sorry, edited the question. I don't want in alphabetical order. – Goku__ Jul 03 '15 at 10:44

user3791372 · Answer 3 · 2015-07-03T10:39:57.107

0

You need to use the order by command. This takes one argument, ASC or DESC for ascending or descending order. Ascending order is A-Z / 1-9, descending order is Z-A / 9-1 etc. The default is asc - that is, if neither asc or desc appears after the order by, it defaults to asc

SELECT a,b FROM foo ORDER BY a

edited Jul 03 '15 at 10:39

answered Jul 03 '15 at 10:33

user3791372

4,445
6
44
78

Get result of select output in proper order

3 Answers3