INDEX_OF

Reference material for INDEX_OF function

Returns the index position of the first occurrence of the element in the array (or NULL if not found).

Syntax

INDEX_OF(<array>, <value>)

Parameters

Parameter	Description	Supported input types
<array>	The array to be analyzed	ARRAY
<value>	The element from the array that is to be matched	Any type that corresponds to an element in the array

Return Type

INTEGER

Example

The following example returns the index position of the 5 in the levels array:

SELECT INDEX_OF([1, 3, 4, 5, 7], 5) AS levels;

levels int null
4

Rows: 1Execution time: 5.48ms