select
*
from
Category
where cateid in ( 535 , 532 , 527 )
order by
case cateid
when 535 then 1
when 532 then 3
when 527 then 2
end
desc
where cateid in ( 535 , 532 , 527 )
order by
case cateid
when 535 then 1
when 532 then 3
when 527 then 2
end
desc
当不能按顺序输出的时候可以按这个顺序来输出