INDEX_OF
Returns the index position of the first occurrence of the element in the array (or 0 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 integer 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;
Returns: 4