关于sql语句的in的问题，大神们帮解答一下被。在线等！！！！！！！！！

[shao1072302877]

select * from `user` where id in (2,3,1)


查出来的借过却是 按从小到大的顺序，如何 还是按这样的顺序查出来

[shinger126]

引用 1 楼 sinat_28984567 的回复:

试试这样

SELECT *
FROM `USER`
WHERE id IN ( 2, 3, 1 )
ORDER BY (CASE
              WHEN id = 2 THEN
                  3
              WHEN id = 3 THEN
                  2
              WHEN id = 1 THEN
                  1
              ELSE
                  0
          END
         ) DESC;

else那部分多余的,条件已经限制了只有1,2,3这3种情况

[吉普赛的歌]

你这个是 mysql 吧：

drop table if EXISTS user_test;
create table user_test(
	id int PRIMARY key,
	n  varchar(20)
);
insert into user_test(id,n) values(1,'a');
insert into user_test(id,n) values(2,'b');
insert into user_test(id,n) values(3,'c');
insert into user_test(id,n) values(4,'d');
-- 以上为测试表及测试数据

select t1.* from user_test as t1
            inner join (select 2 as id,1 as orderBy 
				union all select 1 as id,2 as orderBy 
				union all select 3 as id,3 as orderBy ) as t2
	on t1.id=t2.id
ORDER BY t2.orderBy;

[二月十六]

试试这样

SELECT *
FROM `USER`
WHERE id IN ( 2, 3, 1 )
ORDER BY (CASE
              WHEN id = 2 THEN
                  3
              WHEN id = 3 THEN
                  2
              WHEN id = 1 THEN
                  1
              ELSE
                  0
          END
         ) DESC;

[OwenZeng_DBA]

引用 楼主 shao1072302877 的回复:

select * from `user` where id in (2,3,1) 查出来的借过却是 按从小到大的顺序，如何 还是按这样的顺序查出来

in里面的数字是没有顺序的。你还是从其他业务逻辑来着手吧

[小灰狼]

这样写吧

select 
    *, 
    (case id when 2 then 1 when 3 then 2 when 1 then 3) as OrderSn
where
    id in (2,3,1)
order by OrderSn asc

[volte]

select * from 'user' where id=2 union select * from 'user' where id=3 union select * from 'user' where id=1

[BrucesLong]

楼上已解答，跟IN没关系，就是排序的问题