REGEX_CONTAINS()

All functions > STRING > REGEX_CONTAINS()

Returns TRUE if the haystack string contains a match for the regular expression pattern (substring match; anchors still apply within the search).

Signatures

Returns: TRUE if the pattern matches anywhere in the string, FALSE if it does not; NULL if either argument is NULL

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

Notes

• Matching is case-sensitive unless the pattern uses an inline case-insensitivity flag (e.g. (?i) where supported)
• Returns FALSE when there is no match (not NULL)
• Invalid patterns typically fail the query with an error rather than returning FALSE
• Pair with REGEX_EXTRACT_FIRST / REGEX_EXTRACT_ALL when you need the matched text

Aliases

• REGEXP_CONTAINS

See also

• String functions

Examples

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