mysql操作查询结果case when then else end用法举例

SELECT
  CASE WHEN `MEMBERTYPE` = 1 

　　THEN '参赛队员' 

　　ELSE '指导老师' END
FROM
  `tab_sign_member`
WHERE
  1 = 1