日期:2014-05-17 浏览次数:20510 次
select * from (select '#XL黑色'a union all
select '#S黑色' union all
select '#M黑色' union all
select '#L黑色' union all
select '#XXL黑色')a
order by
case a
when '#S黑色' then 1
when '#M黑色' then 2
when '#L黑色' then 3
when '#XL黑色' then 4
when '#XXL黑色' then 5 end
select * from (select '#XL'a union all
select '#S' union all
select '#M' union all
select '#L' union all
select '#XXL')a
order by
case
when a like '#XXL%' then 5
when a like '#XL%' then 4
when a like '#L%' then 3
when a like '#M%' then 2
when a like '#S%' then 1
end