LIKE_NONE()

All functions > COMPARISON > LIKE_NONE()

TRUE if the string matches LIKE for no pattern in an array.

Signatures

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

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

Notes

• Keyword form: LIKE ANY (pat1, pat2, …) (and ALL / NONE), optional ESCAPE escape; callable / chained forms use ARRAY(...) / ARRAY[...] for patterns and an optional third escape argument
• Wildcards % and _ in each pattern
• Case-sensitive LIKE per pattern
• ANY: TRUE if at least one pattern matches
• ALL: TRUE if every pattern matches (empty pattern list is vacuously TRUE)
• NONE: TRUE if no pattern matches (empty list: TRUE)
• NULL expr1 or NULL patterns → NULL
• BigQuery: this form is not translated (NOT_SUPPORTED)

Related operators

• LIKE multiple

Examples

LIKE_NONE — functional call

SELECT
    f1 := LIKE_NONE('hello', ARRAY['%z%', '%q%']) -- `LIKE_NONE(expr, patterns)` matches keyword `LIKE NONE`
;

LIKE_NONE — chained

SELECT
    f1 := ('hello').LIKE_NONE(ARRAY['%z%', '%q%']) -- Receiver is the string; argument is the pattern array
;