Returns true if a specified argument is present in the array, or false otherwise. Note that ARRAY_CONTAINS employs IS NOT DISTINCT FROM semantics when comparing values, i.e. NULL is considered equal to NULL.

Alias: CONTAINS

​
Syntax

ARRAY_CONTAINS(<array>, <value>)

​
Parameters

ParameterDescriptionSupported input types
<array>The array to be checked for the given element.ARRAY
<value>The element to be searched for within the arrayAny type that can be converted to the element type of the array

​
Return Type

The BOOLEAN value true if the element to be searched is present in the array, or false otherwise.

​
Example

SELECT
	ARRAY_CONTAINS(['sabrina21', 'rileyjon', 'ywilson', 'danielle53', NULL], 'danielle53');

Returns: true, since 'danielle53' is an element of the input array.

SELECT
	ARRAY_CONTAINS(['sabrina21', 'rileyjon', 'ywilson', NULL] , 'danielle53');

Returns: false, since 'danielle53' is not an element of the input array.

SELECT
	ARRAY_CONTAINS(['sabrina21', 'rileyjon', 'ywilson', NULL] , NULL);

Returns: true, since NULL is an element of the input array.