Skip to main content

ARRAY_CONTAINS

Categories: Semi-Structured Data

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.