Skip to main content
Version: 0.0.1

ARRAY_CONTAINS

Categories: Semistructured 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

{{< codeheader "ARRAY_CONTAINS example" >}}

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

{{< codeheader "ARRAY_CONTAINS example" >}}

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

{{< codeheader "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.