https://www.php.cn/sql/442968.html
https://blog.csdn.net/qq_45061258/article/details/122033583
CASE sex
WHEN ‘1’ THEN ‘男’
WHEN ‘0’ THEN ‘女’
ELSE ‘其他’ ENDCASE WHEN sex = ‘1’ THEN ‘男’
WHEN sex = ‘0’ THEN ‘女’
ELSE ‘其他’ ENDhttps://www.php.cn/sql/442968.html
https://blog.csdn.net/qq_45061258/article/details/122033583
CASE sex
WHEN ‘1’ THEN ‘男’
WHEN ‘0’ THEN ‘女’
ELSE ‘其他’ ENDCASE WHEN sex = ‘1’ THEN ‘男’
WHEN sex = ‘0’ THEN ‘女’
ELSE ‘其他’ END