THEN ‘参赛队员‘
ELSE ‘指导老师‘
END FROM `tab_sign_member`
WHERE 1
mysql操作查询结果case when then else end用法举例
标签：
mysql操作查询结果case when then else end用法举例
CASE WHEN `MEMBERTYPE` =1
THEN ‘参赛队员‘
ELSE ‘指导老师‘
END FROM `tab_sign_member`
WHERE 1
THEN ‘参赛队员‘
ELSE ‘指导老师‘
END FROM `tab_sign_member`
WHERE 1