ILIKE_ANY()

All functions > COMPARISON > ILIKE_ANY()

TRUE if the string matches ILIKE for at least one pattern in an array.

Signatures

Returns: TRUE, FALSE, or NULL following three-valued logic for NULL inputs or pattern elements

ILIKE_ANY(expr1: VARCHAR, patterns: ARRAY(VARCHAR), [escape: VARCHAR]) → BOOLEAN

Notes

• Keyword form: ILIKE ANY (pat1, pat2, …) (and ALL / NONE), optional ESCAPE escape; callable / chained forms use ARRAY(...) / ARRAY[...] and an optional third escape argument
• Wildcards % and _ in each pattern
• Case-insensitive ILIKE per pattern where the dialect supports it; otherwise lowercasing is used in translation
• Same ANY / ALL / NONE rules as LIKE_* on arrays
• NULL expr1 or NULL patterns → NULL
• BigQuery: this form is not available (denylist)

Related operators

• LIKE multiple

Examples

ILIKE_ANY — functional call

SELECT
    -- `ILIKE_ANY(expr, patterns)` matches keyword `ILIKE ANY`
    f1 := ILIKE_ANY('Hello', ARRAY('%xx%', '%ll%'))
;

ILIKE_ANY — chained

SELECT
    -- Receiver is the string; argument is the pattern array
    f1 := ('Hello').ILIKE_ANY(ARRAY('%xx%', '%ll%'))
;