SELECT id ,(CASE WHEN nameabbr
= ‘’ THEN name
WHEN nameabbr
IS NULL THEN name
ELSE nameabbr END ) AS sex
FROM base_projectinfo;
MySql case then用法
最新推荐文章于 2023-05-30 16:39:32 发布
SELECT id ,(CASE WHEN nameabbr
= ‘’ THEN name
WHEN nameabbr
IS NULL THEN name
ELSE nameabbr END ) AS sex
FROM base_projectinfo;