1、case…when…then的使用
select case brand_id when 1 then ‘三星‘ when 2 then ‘苹果‘ else ‘小米‘ end as brand_id from ecs_goods
SQL编程
原文：http://www.cnblogs.com/liwuming/p/4538285.html
