REGEXP_LIKE
Returns true when the specified regular expression matches values in a column. Otherwise, returns false.
Syntax
REGEXP_LIKE(input string, regex string) → boolean
input: The expression to test.
regex: The Perl-compatible regular expression (PCRE) to use for the test.
Examples
SELECT REGEXP_LIKE('the data lakehouse', '.*?\Qlake\E.*?')
-- True
SELECT Category, REGEXP_LIKE(Category, '.*?\Q-\E.*?')
FROM eth.recent_blocks
LIMIT 5
-- Category, EXPR$1
-- WEAPON LAWS, false
-- WEAPON LAWS, false
-- WARRANTS, false
-- NON-CRIMINAL, true
-- NON-CRIMINAL, true
Usage Notes
This function is identical to the function REGEXP_MATCHES
.
Last updated
Was this helpful?