SELECT *, id AS Expr1
FROM City
WHERE (id IN (5,2,3,1))

输出后 id 排列 为 1，2，3，5
怎么样可以按照5，2，3，1 无变化输出


希望 高人指教

你order by id desc不行吗

SELECT *, id AS Expr1
FROM City
WHERE (id IN (5,2,3,1))

group by case when id = 5 then 1 when id = 2 then 2 when id =3 then 3 else 1 end

轻轻 的问一句
IN是干吗用的？在网上查了
不怎么明白