按指定ID值顺序排列

admin

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,','))