regexp_matches()

Returns true if string contains the regex, false otherwise. A set of optional regex 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_matches('anabanana', '(an)*');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT 'ThOmAs' ~* 'thomas'

In Haybarn

SELECT REGEXP_MATCHES('ThOmAs', 'thomas', 'i')

a RLIKE 'x'

In Haybarn

REGEXP_MATCHES(a, 'x')

REGEXP_LIKE(a, 'x')

In Haybarn

REGEXP_MATCHES(a, 'x')