case when else

select *,(case when table_no>50 then 'no' else 'yes' end) as result
from member_info_mapping
where uuid <=5000 and table_no >=30

 

 使用 CASE 处理条件数据

CASE  input_expression    

WHEN when_expression

THEN result_expression         [ ...n ]    

[         ELSE else_result_expression     ]

END