regexp_full_match()

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

Reference: DuckDB 2.0.0

Arguments & returns

2 overloads

regexp_full_match(string, regex)

Scalar
Overload link stringregex Returns
#01 VARCHARVARCHAR BOOLEAN

regexp_full_match(string, regex, options)

Scalar
Overload link stringregexoptions Returns
#02 VARCHARVARCHARVARCHAR BOOLEAN

Example

regexp_full_match example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.

In other engines

Snowflake

SELECT a RLIKE b
In DuckDB
SELECT REGEXP_FULL_MATCH(a, b)

SQLGlot example ↗