MySQL按多个项目查询顺序

Question

是否可以按多行排序？

我希望我的用户按 last_activity 排序，但同时我希望有图片的用户出现在没有图片的用户之前

类似这样的:

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

Answer 1

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

Note that we can place ASC or DESC after each column (like above does for pic_set), or leave it to default (like above's last_activity-column).