REGEX_CONTAINS

All functions > STRING > REGEX_CONTAINS

Returns TRUE if a string contains a match for a regular expression pattern.

Signatures

Returns: TRUE if the pattern matches anywhere in the string, FALSE otherwise

REGEX_CONTAINS(string: VARCHAR, pattern: VARCHAR) → BOOLEAN

sql

Parameter	Type	Required	Description
`string`	`VARCHAR`	Yes	String to search in
`pattern`	`VARCHAR`	Yes	Regular expression pattern to match

Notes

The pattern can match anywhere in the string (partial match)
Uses RE2-style regular expressions
Case-sensitive by default; use (?i) flag for case-insensitive matching
Returns FALSE if either input is NULL

Examples

FeatureQL

SELECT
    f1 := REGEX_CONTAINS('Hello World', 'World'),  -- Literal match
    f2 := REGEX_CONTAINS('Hello World', '^Hello'),  -- Anchored at start
    f3 := REGEX_CONTAINS('Hello World', '^World'),  -- Anchor fails
    f4 := REGEX_CONTAINS('abc123', '[0-9]+'),  -- Digit pattern
    f5 := REGEX_CONTAINS('hello', '[A-Z]'),  -- Case-sensitive
    f6 := REGEX_CONTAINS('user@example.com', '.+@.+\..+')  -- Email-like pattern
;

Result

f1 BOOLEAN	f2 BOOLEAN	f3 BOOLEAN	f4 BOOLEAN	f5 BOOLEAN	f6 BOOLEAN
true	true	false	true	false	true

Suggest changes to this page

Last update at: 2026/03/03 16:47:38

On this page

Signatures Notes Examples