foart的专栏

转：http://www.cnblogs.com/zeroone/archive/2010/03/31/1701062.html 本人下载的MySQL是5.1版的 下载地址： http://dev.mysql.com/downloads/mysql/ 下载 免安装包(mysql-noinstall-5.1.45-win32.zip) 解压该压缩文件到E:\mysql-5.

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