SHOW:
|
|
- or go back to the newest paste.
| 1 | CASE | |
| 2 | - | WHEN REGEXP_MATCH(Source, ".*facebook.*") THEN "Facebook" |
| 2 | + | WHEN REGEXP_MATCH(page, ".*facebook.*") THEN "Facebook" |
| 3 | - | WHEN REGEXP_MATCH(Source, ".*instagram.*") THEN "Instagram" |
| 3 | + | WHEN REGEXP_MATCH(page, ".*instagram.*") THEN "Instagram" |
| 4 | - | WHEN REGEXP_MATCH(Source, ".*linkedin.*") THEN "Linkedin" |
| 4 | + | WHEN REGEXP_MATCH(page, ".*linkedin.*") THEN "Linkedin" |
| 5 | - | WHEN REGEXP_MATCH(Source, ".*youtube.*") THEN "Youtube" |
| 5 | + | WHEN REGEXP_MATCH(page, ".*youtube.*") THEN "Youtube" |
| 6 | - | WHEN REGEXP_MATCH(Source, ".*snapchat.*") THEN "Snapchat" |
| 6 | + | WHEN REGEXP_MATCH(page, ".*snapchat.*") THEN "Snapchat" |
| 7 | - | WHEN REGEXP_MATCH(Source, ".*pinterest.*") THEN "Pinterest" |
| 7 | + | WHEN REGEXP_MATCH(page, ".*pinterest.*") THEN "Pinterest" |
| 8 | - | WHEN REGEXP_MATCH(Source, ".*t\\.co*") THEN "Twitter" |
| 8 | + | ELSE page |
| 9 | - | WHEN REGEXP_MATCH(Source, ".*lnkd\\.in*") THEN "Linkedin" |
| 9 | + | |
| 10 | - | ELSE Source |
| 10 | + |
