sql查询替换值的操作

select mainbody,
       (case mainbody
           when 1 then "未完成"
           when 2 then "已完成"
           else "其他"
           end)
from base_info;