ALL_MATCH

Returns 1 (true) when the Boolean expression <condition> performed on all elements of an array evaluate to true. Returns 0 (false) when any one comparison evaluates to false.

Syntax

ALL_MATCH(<expression> -> <condition>, <array>)

Parameters

Parameter	Description	Supported input types
`<expression>`	A Lambda array variable that contains elements of the `<array>` specified. For more information, see Manipulating arrays with Lambda functions.	Same as the element data type of the input array
`<condition>`	A Boolean expression that evaluates each array value using a comparison operator.	See Comparison operators.
`<array>`	The array to evaluate.	`ARRAY`

Return Types

Returns 1 if the condition is met
Returns 0 if the condition returns false

Examples

Return 1 (true) if all elements in the array are greater than 0.

SELECT
	ALL_MATCH(x -> x > 0, [ 1, 2, 3, 9 ]) AS current_levels;

Returns:

current_levels
1

Return 1 (true) if esimpson does not appear in the current_players array.

SELECT
	ALL_MATCH(x -> x <> 'esimpson', [ 'kennethpark', 'sabrina21', 'steven70']) AS current_players;

Returns:

current_players
0