SELECT CASE `user_gender` WHEN '1' THEN '男' WHEN '0' THEN '未知'ELSE '女' END AS gender FROM `info_user`
Sql语句将0 1转化为男女性别
最新推荐文章于 2024-05-24 22:53:48 发布
SELECT CASE `user_gender` WHEN '1' THEN '男' WHEN '0' THEN '未知'ELSE '女' END AS gender FROM `info_user`