Link Search Menu Expand Document

CONTAINS

Returns whether the array passed as the first argument contains the value passed as the second argument.

Syntax 

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 The array elements’ type

Return Type

BOOLEAN

  • Returns true if the element to be searched is present in the array
  • Returns false if the element is not present in the array

Example 

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

Returns: true as “danielle53” is part of the array.

CONTAINS returns false when the value is not contained in the array:

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

Returns: false as “danielle53” is not part of the array.