SELECT id, gsmc,
CASE WHEN xm IS NULL
THEN '无'
ELSE xm
END AS my_myname
FROM `oa_wdxsc`
LIMIT 0 , 30
mysql case when then else end 实践
最新推荐文章于 2023-04-24 15:53:08 发布
SELECT id, gsmc,
CASE WHEN xm IS NULL
THEN '无'
ELSE xm
END AS my_myname
FROM `oa_wdxsc`
LIMIT 0 , 30