mysql SQL:首先要特定项目，然后对其余项目进行排序
假设我有下表.
我想得到所有的朋友，但我想让 id 5 成为列表中的第一项.我不在乎收到其余物品的订单.
I want to get all the friends, but I want the id 5 to be the first item in the list. I don't care about the order that I receive the rest of the items.
所需的查询结果为:
friends
-------
id name
5 nahum
1 moshe
2 haim
3 yusuf
4 gedalia
6 dana
我该怎么做?
使用 Mysql 5.1.x.
using Mysql 5.1.x.
谢谢！
推荐答案
select id,name
from friends
order by id=5 desc
(假设您不关心其余部分的顺序，否则，例如 rest by id asc)
(given you don't care about order of the rest, otherwise, e.g. rest by id asc)
select id,name
from friends
order by id=5 desc, id asc
相关文章