MySQL query order by multiple items

Question

Will it be possible to order by multiple rows?

I need my users to be sorted by last_activity, yet at the same time, I need the users with pictures to appear before the ones without

Something like this:

SELECT some_cols
FROM `prefix_users`
WHERE (some conditions)
ORDER BY last_activity, pic_set DESC;

Answer 1

You can use this following query:

SELECT some_cols
FROM prefix_users
WHERE (some conditions)
ORDER BY pic_set DESC, last_activity;

 Want to become an expert in SQL? Join the SQL course fast!