Skip to main content
Version: 24.3.x

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.