sql in按照指定顺序排序

 

 

如下

Select * 
FROM table1 
Where ID IN (3,5,1,4,2)
order by field (3,5,1,4,2)