MySQL sorting multiple rows

Question

I want to sort on strProjectName and strJobName, but I want to prioritize strProjectName. Using the regular order by method: ORDER BY strProjectName, strJobName ASC does work, but not when sorting DESC, due to the fact it will sort on strJobName instead.

TL;DR: I want to sort first on strProjectName and then on strJobName. (And yes, there are more fields).

dee-see · Accepted Answer · 2011-08-16 14:13:35Z

1

You have to specify ORDER BY strProjectName DESC, strJobName DESC or else ASC will be assumed for strProjectName.

answered Aug 16, 2011 at 14:13

dee-see

24.1k6 gold badges63 silver badges92 bronze badges

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

Comments

Casper · Accepted Answer · 2011-08-16 14:13:42Z

1

You can mix ordering by different columns like so:

ORDER BY a DESC, b ASC

answered Aug 16, 2011 at 14:13

Casper

34.5k4 gold badges89 silver badges84 bronze badges

Collectives™ on Stack Overflow

MySQL sorting multiple rows

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related