outbound to social meida

CASE
WHEN REGEXP_MATCH(page, ".*facebook.*") THEN "Facebook"
WHEN REGEXP_MATCH(page, ".*instagram.*") THEN "Instagram"
WHEN REGEXP_MATCH(page, ".*linkedin.*") THEN "Linkedin"
WHEN REGEXP_MATCH(page, ".*youtube.*") THEN "Youtube"
WHEN REGEXP_MATCH(page, ".*snapchat.*") THEN "Snapchat"
WHEN REGEXP_MATCH(page, ".*pinterest.*") THEN "Pinterest"
ELSE page

END