ARRAY_CONTAINS

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

Parameter Description Supported input types
<array> The array to be checked for the given element. ARRAY
<value> The element to be searched for within the array Any 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.