DuckDB function regexp_full_match

Returns true if the entire string matches the regex. A set of optional regex options can be set.

Usage

regexp_full_match(string, regex, col2)

Arguments

string, regex, col2

VARCHAR

Value

BOOLEAN

Overloads

• regexp_full_match(string = VARCHAR, regex = VARCHAR)

• regexp_full_match(string = VARCHAR, regex = VARCHAR, col2 = VARCHAR)

SQL examples

regexp_full_match('anabanana', '(an)*')

See also

Other regex: regexp_escape(), regexp_extract(), regexp_extract_all(), regexp_matches(), regexp_replace(), string_split_regex()