mysql中 case when tmp is null then sql判断字段值是否为空，如果为空给一个值

case when tmp is null then '实际预验' else split_part(split_part(tmp,',',1),':',1) end as text,

case when tmp is null then to_char(now(),'yyyy-mm-dd') else split_part(split_part(tmp,',',1),':',2) end as start_date,

case when tmp is null then '0' else split_part(split_part(tmp,',',1),':',3) end as duration