摘要:
SELECT*FromAdminWHEREIDin(3,4,10,6)查询结果:Id Title----------- ---------------3 LFan4 ZXin6 YSXun10 WWhua想根据id顺序进行排序,显示成如下:Id Title----------- ---------------3 LFan4 ZXin10 WWhua6 YSXunSELECT*FromAdminWHEREIDin(3,4,10,6)orderbycharindex(cast(idasvarchar),'3,4,10,6')
阅读全文