sql一:
select * from tabname where 1=1 order by CHARINDEX(RTRIM(CAST(列名 as NCHAR)),'北京,上海,广州')
sql二:
select * from tabname where id in(1,2,3,4,5)
order by charindex(','+convert(varchar,id)+',','2,4,5,1,3')
sql三:
select * from tabname Where id IN (1,2,3,4,5)
order by CHARINDEX(RTRIM(CAST(id as NCHAR)),'2,4,5,1,3')