case when sale_type = '4' then '精选' else null end as sale_type 注意: end不能少 转载于:https://www.cnblogs.com/drjava/p/10678473.html