SQL语句积累

条件

select ied_id as iedId, tripinfo_id as action_id, name, '类型' as stype,
 (case cur_value 
 when 0 then '替换值1'
 when 1 then '替换值2'
 when 'False' then '替换值3'
 when 'True' then '替换值4'
 else cur_value/*否则等于本身*/
 end) as cur_value
from sduent_table