ARRAY_CONTAINS

Returns whether a list contains a given value.

Syntax

ARRAY_CONTAINS(list LIST, value any) → boolean

• list: The list to search.

• value: An expression of a type that is comparable with the LIST.

Examples

ARRAY_CONTAINS example

SELECT ARRAY_CONTAINS(CONVERT_FROM('["apple", "pear", "banana"]', 'json'), NULL)
-- null

ARRAY_CONTAINS example

SELECT ARRAY_CONTAINS(CONVERT_FROM('["apple", "pear", "banana"]', 'json'), 'pear')
-- true

ARRAY_CONTAINS example

SELECT ARRAY_CONTAINS(CONVERT_FROM('["apple", "pear", "banana"]', 'json'), 'grape')
-- false

Usage Notes

If value is NULL, the result is NULL. If NULL is in list and value is not in list, the result is NULL. If value is present in the list, the result is TRUE. Otherwise, the result is FALSE.