MySQL double sort

Question

I would like to double my list of users. Is this possible in a single MySQL query?

For instance:

 1 Jack Active 2 Jill Active 5 Jens Active 3 Harry Inactive 4 Larry Inactive 6 Luke Inactive

+6

John Apr 18 '12 at 15:14

5 answers

 SELECT id, name, activity FROM your_table ORDER BY activity ASC, id ASC

+4

Ike walker Apr 18 '12 at 15:16

 Select * from table order by activity, ID;

+1

chance Apr 18 '12 at 15:16

 SELECT * FROM table_name ORDER BY activity, ID;

+1

Teun zengerink Apr 18 '12 at 15:16

Yes,

 SELECT (user.name|| ' ' || user.status) AS sorted_list FROM STUDENTS ORDER BY user.status, user.name

0

eCoder Apr 18 '12 at 15:18

Taryn · Accepted Answer · 2012-04-18T15:16:36+0000

You can use the ORDER BY to sort as many columns as possible.

 SELECT id, name, activity FROM userList ORDER BY Activity, ID

I would suggest reading the MySQL ORDER BY docs. You can sort the data in ASC or DESC order: MySQL: ORDER optimization