mysql, in clause order

카테고리 없음 2021. 6. 9. 10:43

-- in clause order
create table test111 (num int);
insert into test111 values (1);
insert into test111 values (2);
insert into test111 values (3);
insert into test111 values (4);
insert into test111 values (5);
insert into test111 values (6);
insert into test111 values (7);
insert into test111 values (8);
insert into test111 values (9);
insert into test111 values (10);
insert into test111 values (11);
insert into test111 values (12);
insert into test111 values (13);
insert into test111 values (14);
insert into test111 values (15);
insert into test111 values (16);
select * from test111;

SELECT * FROM test111
WHERE num IN (5,2,6,8,12,1)
ORDER BY FIELD(num,5,2,6,8,12,1);