-
数据表数据如下：
image.png
-
SQL语句：
SELECT
b.id,
b.birthday,
CASE
b.employe_prove
WHEN 0 THEN
'未认证'
WHEN 1 THEN
'已认证' ELSE '未认证'
END AS employe_prove_new
FROM
cmf_user AS b
WHERE
id = 9;
或者
SELECT
b.id,
b.birthday,
CASE
WHEN b.employe_prove = 0 THEN
'未认证'
WHEN b.employe_prove = 1 THEN
'已认证' ELSE '未认证'
END AS employe_prove_new
FROM
cmf_user AS b
WHERE
id = 9;
-
查询结果如下：
image.png
网友评论