一,MySQL if 语句用法:
SELECT IF(gender='男',1,2) from physical_enroll_info;
二,MySQL 中 case when then … else end 的简单使用:
SELECT CASE usercenter.physical_enroll_info.gender WHEN '女' THEN 2 WHEN '男' THEN 1 ELSE 'null' END from physical_enroll_info;
打印: