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.

Examples

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

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

array_contains boolean
True

Rows: 1Execution time: 5.39ms

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

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

array_contains boolean
False

Rows: 1Execution time: 41.26ms

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

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

array_contains boolean
True

Rows: 1Execution time: 10.20ms

ARRAY_CONCAT

ARRAY_COUNT_DISTINCT

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Parameters

Return Type

Examples

​Syntax

​Parameters

​Return Type

​Examples

Syntax

Parameters

Return Type

Examples