How to ORDER mysql rows by multiple columns?

Question

such as "order by col_location", if location is the same, then "order by col_time"

Henrik Adolfsson · Accepted Answer · 2009-12-12 12:38:18Z

4

SELECT * FROM something
ORDER BY col_location, col_time DESC;

answered Dec 12, 2009 at 12:38

Henrik Adolfsson

6093 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

duffymo · Accepted Answer · 2009-12-12 12:38:27Z

1

You can string columns in an ORDER BY, separated by commas.

answered Dec 12, 2009 at 12:38

duffymo

310k46 gold badges377 silver badges572 bronze badges

Comments

davek · Accepted Answer · 2009-12-12 12:38:03Z

0

As others have said,listing the different columns in order of priority. You can also go one step further and build logic into your ORDER BY so that it becomes conditional e.g.

order by case when col_location = col_something_else then 
   col_location 
else 
   col_time 
end

answered Dec 12, 2009 at 12:38

davek

23k11 gold badges80 silver badges97 bronze badges

Collectives™ on Stack Overflow

How to ORDER mysql rows by multiple columns?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related