where in的sql语句按照指定ID进行排序的解决方法

Access:
select * From 表 Where id in(1,5,3) order by instr(',1,5,3,',','&id&',')

 

MSSQL:
select * From 表 Where id in(1,5,3) order by charindex(','+rtrim(cast(id as varchar(10)))+',',',1,5,3,')

 

MySQL:
select * From 表 Where id in (1,5,3) order by instr(',1,5,3,',',CONCAT(',',id,','))