mysql按多个项目查询顺序 [英] mysql query order by multiple items

问题描述

是否可以按多行订购?

is is possible to order by multiple rows?

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

I want my users to be sorted by last_activity, but at the same time, i want the users with pictures to appear before the ones without

类似这样的东西:

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

推荐答案

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

这篇关于mysql按多个项目查询顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！