where id in 排序 按in的顺序排
摘要: 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(阅读全文
posted @ 2011-07-02 11:15 Jela 阅读(81) | 评论 (0) 编辑