我的代码如下,我想在一个case语句中将4 like语句合并为1
SELECT
* ,
CASE
WHEN LOWER(campaign_name) LIKE ('bra_de_%'OR'%-de'OR'vid_de_%'OR 'de_%') THEN 'de'
ELSE '0'
END AS country,
FROM abc
有人能帮帮我吗?谢谢!
尝试使用BigQueryREGEXP_CONTAINS
函数,并将您的模式与|
连接起来,如下所示:
SELECT *,
CASE WHEN REGEXP_CONTAINS(LOWER(campaign_name),
r'^bra[_]de[_].*|.*-de$|^vid[_]de[_].*|^de[_].*')
THEN 'de'
ELSE '0'
END AS country
FROM abc