select mainbody,
(case mainbody
when 1 then "未完成"
when 2 then "已完成"
else "其他"
end)
from base_info;
sql查询替换值的操作
最新推荐文章于 2023-08-03 18:17:13 发布
select mainbody,
(case mainbody
when 1 then "未完成"
when 2 then "已完成"
else "其他"
end)
from base_info;