sql查询按照in语句的顺序返回结果

SELECT * FROM example WHERE id IN('4','3','2','1') ORDER BY INSTR('4,3,2,1',id);

SELECT * FROM example WHERE id IN(4,3,2,1) ORDER BY INSTR(',4,3,2,1,',CONCAT(',',id,','));

select name from example where id in（4,3,2,1）order by instr('4,3,2,1',id);

Select * From example Where id in (4,3,2,1)  Order By charindex(','+ id +',', ',4,3,2,1,');