【Mysql】 case ... when ... 用法时间:2023-03-10 03:37:28 sql语句查询时给某个空字段赋值 SELECT CASE WHEN field= '' THEN '' WHEN fieldIS NULL THEN '' ELSE field END FROM tablename