SQL 查询结果按参数顺序排列
时间:2022-03-14 05:04
SELECT * FROM Project_Business_Type WHERE Id in (10,25,5,4,15,46,74,500) order by charindex(‘,‘+ltrim(Id)+‘,‘, ‘,10,25,5,4,15,46,74,500,‘)
这里查询出来的结果就是按参数传进来的顺序,10,25,5,4...
order by charindex(‘,‘+ltrim(Id)+‘,‘, ‘,10,25,5,4,15,46,74,500,‘) 排列顺序