Sql查询按照in语句的顺序排列

君山

mysql写法

[mw_shl_code=sql,true]
SELECT * FROM table WHERE id IN (6,5,1,4) ORDER BY FIELD(id,6,5,4,1);
SELECT * FROM table WHERE id IN (6,5,1,4) ORDER BY INSTR(',6,5,1,4,',CONCAT(',',id,','));
[/mw_shl_code]


sqlite写法

[mw_shl_code=sql,true]
SELECT * FROM table WHERE id IN('6','5','1','4') ORDER BY INSTR('6,5,1,4',id);
[/mw_shl_code]


oracle写法

[mw_shl_code=sql,true]
SELECT * FROM table WHERE id IN (6,5,1,4) ORDER BY INSTR('6,5,1,4',id);
[/mw_shl_code]


sqlserver写法

[mw_shl_code=sql,true]
SELECT * FROM table WHERE id IN (6,5,1,4) ORDER BY CHARINDEX(','+ id +',', ',6,5,1,4,');
[/mw_shl_code]