写写程序,一种成就的感觉

写写程序,一种成就的感觉

导航

SQL语句之按in排序

Posted on 2009-12-21 14:28  hateyoucode  阅读(2510)  评论(0编辑  收藏  举报

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