select mch_nm as merchant_name,case whenmch_nm like '%上海寻梦%' or mch_nm like '%拼多多%'then '拼多多' whenmch_nm like '%京东%' then '京东' whenmch_nm like '%淘宝%'or mch_nm like '%天猫%' or mch_nm like '%杭州今日卖场%' then '淘系' whenmch_nm like '%合众%' or mch_nm like '%空间变%'or mch_nm like '%抖音%'then '抖音'when mch_nm like '%行吟%'or mch_nm like '%小红书%' then '小红书' else '其他' end as platformfrom (select * from ccb_trx_rcd where left(mch_nm,1) != '财')a
select mch_nm as merchant_name,case whenmch_nm like '%上海寻梦%' or mch_nm like '%拼多多%'then '拼多多' whenmch_nm like '%京东%' then '京东' whenmch_nm like '%淘宝%'or mch_nm like '%天猫%' or mch_nm like '%杭州今日卖场%' then '淘系' whenmch_nm like '%合众%' or mch_nm like '%空间变%'or mch_nm like '%抖音%'then '抖音'when mch_nm like '%行吟%'or mch_nm like '%小红书%' then '小红书' else '其他' end as platformfrom ccb_trx_rcd
select mch_nm as merchant_name,case whenmch_nm like '%上海寻梦%' or mch_nm like '%拼多多%'then '拼多多' whenmch_nm like '%京东%' then '京东' whenmch_nm like '%淘宝%'or mch_nm like '%天猫%' or mch_nm like '%杭州今日卖场%' then '淘系' whenmch_nm like '%合众%' or mch_nm like '%空间变%'or mch_nm like '%抖音%'then '抖音'when mch_nm like '%行吟%' then '小红书' else '其他' end as platformfrom ccb_trx_rcd
select mch_nm as merchant_name,case whenmch_nm like '%上海寻梦%' or mch_nm like '%拼多多%'then '拼多多' whenmch_nm like '%京东%' then '京东' whenmch_nm like '%淘宝%'or mch_nm like '%天猫%' or mch_nm like '%杭州今日卖场%' then '淘系' whenmch_nm like '%合众%' or mch_nm like '%空间变幻%'or mch_nm like '%抖音%'then '抖音'when mch_nm like '%行吟%' then '小红书' else '其他' end as platformfrom ccb_trx_rcd
select mch_nm as merchant_name,case whenmch_nm like '%寻梦%' or mch_nm like '%拼多多%'then '拼多多' whenmch_nm like '%京东%' then '京东' whenmch_nm like '%淘宝%'or mch_nm like '%天猫%' or mch_nm like '%杭州今日卖场%' then '淘系' whenmch_nm like '%合众%' or mch_nm like '%空间变幻%'or mch_nm like '%抖音%'then '抖音'when mch_nm like '%行吟%' then '小红书' else '其他' end as platformfrom ccb_trx_rcd
select mch_nm as merchant_name,case whenmch_nm like '%上海寻梦%' or mch_nm like '%拼多多%'then '拼多多' whenmch_nm like '%京东%' then '京东' whenmch_nm like '%淘宝%'or mch_nm like '%天猫%' or mch_nm like '%杭州今日卖场%' then '淘系' whenmch_nm like '%合众%'or mch_nm like '%抖音%'then '抖音'when mch_nm like '%行吟%' then '小红书' else '其他' end as platformfrom ccb_trx_rcd
select mch_nm as merchant_name,case whenmch_nm like '%上海寻梦%'then '拼多多' whenmch_nm like '%京东%' then '京东' whenmch_nm like '%淘宝%'or mch_nm like '%天猫%' or mch_nm like '%杭州今日卖场%' then '淘系' whenmch_nm like '%合众%'or mch_nm like '%抖音%'then '抖音'when mch_nm like '%行吟%' then '小红书' else '其他' end as platformfrom ccb_trx_rcd
select mch_nm as merchant_name,case when substr(mch_nm,5,6)= '拼' or mch_nm like '%上海寻梦%'then '拼多多' when substr(mch_nm,1,2)= '京' or mch_nm like '%京东%' then '京东' when substr(mch_nm,5,6)= '淘' or mch_nm like '%淘宝%'or mch_nm like '%天猫%' or mch_nm like '%杭州今日卖场%' then '淘系' when substr(mch_nm,5,6)= '抖' or mch_nm like '%合众%'or mch_nm like '%抖音%'then '抖音'when substr(mch_nm,5,6)= '小'or mch_nm like '%行吟%' then '小红书' else '其他' end as platformfrom ccb_trx_rcd
select mch_nm as merchant_name,case when substr(mch_nm,5,6)= '拼' or mch_nm like '%上海寻梦%'then '拼多多' when substr(mch_nm,1,2)= '京' or mch_nm like '%京东%' then '京东' when substr(mch_nm,5,6)= '淘' or mch_nm like '%淘宝%'or mch_nm like '%天猫%' then '淘系' when substr(mch_nm,5,6)= '抖' or mch_nm like '%合众%'or mch_nm like '%抖音%'then '抖音'when substr(mch_nm,5,6)= '小'or mch_nm like '%行吟%' then '小红书' else '其他' end as platformfrom ccb_trx_rcd