array_contains
function
Applies to: Databricks SQL Databricks Runtime
Returns true if array
contains value
.
Syntax
array_contains(array, value)
Arguments
array
: An ARRAY to be searched.value
: An expression with a type sharing a least common type with thearray
elements.
Returns
A BOOLEAN.
If value
is NULL
, the result is NULL
.
If any element in array
is NULL
, the result is NULL
if value
is not matched to any other element.
Examples
> SELECT array_contains(array(1, 2, 3), 2);
true
> SELECT array_contains(array(1, NULL, 3), 2);
NULL
> SELECT array_contains(array(1, 2, 3), NULL);
NULL