ILIKE_ALL()

All functions > COMPARISON > ILIKE_ALL()

TRUE if the string matches ILIKE for every pattern in an array.

Signatures

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

ILIKE_ALL(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 translated (NOT_SUPPORTED)

Related operators

• LIKE multiple

Examples

ILIKE_ALL — functional call

SELECT
    f1 := ILIKE_ALL('Hello', ARRAY['%e%', '%o']) -- `ILIKE_ALL(expr, patterns)` matches keyword `ILIKE ALL`
;

ILIKE_ALL — chained

SELECT
    f1 := ('Hello').ILIKE_ALL(ARRAY['%e%', '%o']) -- Receiver is the string; argument is the pattern array
;