INDEX_OF

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

Syntax

INDEX_OF(<array>, <value>)

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

INTEGER

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

⌘I