根据in条件来排序结果select * from 表名 where butxt in ('a','b','c',) order by charindex(','+butxt+',',',a,,b,,c,')