SELECT CASE WHEN `MEMBERTYPE` = 1 THEN ‘参赛队员‘ ELSE ‘指导老师‘ END FROM `tab_sign_member` WHERE 1 = 1
mysql操作查询结果case when then else end用法举例,布布扣,bubuko.com
mysql操作查询结果case when then else end用法举例
原文:http://www.cnblogs.com/ganymede/p/3872437.html