多个if查询及case when 语句

oktokeep

发布于 2024-10-09 09:54:47

9620

concat( if(t2.`flow_flag`=1 and t1.`field_source`= '06','支付宝账号1',''), if(t2.`flow_flag`=0 and t1.`field_source`= '06','支付宝账号2',''), if(t2.`flow_flag`=1 and t1.`field_source`= '07','微信账号1',''), if(t2.`flow_flag`=0 and t1.`field_source`= '07','微信账号2','')) as '账号',

case `field_source` when 1 then '支付宝' when 2 then '微信' end as '支付来源',

本文参与腾讯云自媒体同步曝光计划，分享自作者个人站点/博客。

原始发表：2022-07-25，如有侵权请联系 cloudcommunity@tencent.com 删除

field