regexp_matches.md

description
Returns true when the specified regular expression matches values in a column. Otherwise, returns false.

REGEXP_MATCHES

Syntax

REGEXP_MATCHES(input string, regex string) → boolean

• input: The expression to test.
• regex: The Perl-compatible regular expression (PCRE) to use for the test.

Examples

{% code title="REGEXP_MATCHES example" %}

SELECT REGEXP_LIKE('the data lakehouse', '.*?\Qlake\E.*?')
-- True

{% endcode %}

{% code title="REGEXP_MATCHES example" %}

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

{% endcode %}

Usage Notes

This function is identical to the function REGEXP_LIKE.