SELECT CURDATE() AS ‘日期‘, (CASE tableA.gender WHEN ‘0‘ THEN ‘男‘ WHEN ‘1‘ THEN ‘女‘ ELSE DATE_SUB(CURDATE(),INTERVAL 1 DAY) END ) AS ‘性别, FROM tableA
根据查询结果值显示结果
原文：https://www.cnblogs.com/stuka/p/11798345.html
