SQL CASE WHEN 语句：根据 value 字段内容进行赋值
SELECT CASE WHEN value = '是' THEN '是' WHEN value = '否' THEN '否' WHEN value IS NULL THEN '' ELSE value END AS new_value FROM table_name;
原文地址: https://www.cveoy.top/t/topic/qlKD 著作权归作者所有。请勿转载和采集!
安全问答是一个知识全球问答,包含丰富的问答知识
SELECT CASE WHEN value = '是' THEN '是' WHEN value = '否' THEN '否' WHEN value IS NULL THEN '' ELSE value END AS new_value FROM table_name;
原文地址: https://www.cveoy.top/t/topic/qlKD 著作权归作者所有。请勿转载和采集!