CASE sex
WHEN '1' THEN '男'
WHEN '2' THEN '女'
ELSE '其他' END
https://www.cnblogs.com/clphp/p/6256207.html
2、通过sql展示项目对应的任务是否下发(如果rwid不为null,则是;反之,否)
SELECT aa.*,
CASE
WHEN rwid IS NULL THEN 0
ELSE 1
END rwxf
FROM
(SELECT xm.id,
xm.xmmc,
rw.id rwid,
rw.xmmc rwxmmc
FROM uf_xm xm
LEFT JOIN uf_rw rw ON xm.xmmc = rw.xmmc) aa