regexp_full_match()

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

Arguments & returns

2 overloads

Scalar

Overload link	`string`	`regex[`	Returns
#01	`VARCHAR`	`VARCHAR`	`BOOLEAN`

Scalar

Overload link	`string`	`regex[`	`options]`	Returns
#02	`VARCHAR`	`VARCHAR`	`VARCHAR`	`BOOLEAN`

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

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT a RLIKE b

In DuckDB

SELECT REGEXP_FULL_MATCH(a, b)