case when then end 用法

select type,numbers,case monthst
when 1 then '一月'
when 2 then '二月'
when 3 then '三月'
else '其他月'
end monthst from capacity;

原文地址:https://www.cnblogs.com/mryangbo/p/10755197.html