INDEX_OF
Returns the index position of the first occurrence of the element in the array (or 0 if not found).
Syntax
INDEX_OF(<arr>, <x>)
| Parameter | Description |
|---|---|
<arr> | The array to be analyzed. |
<x> | The element from the array that is to be matched. |
Example
SELECT
INDEX_OF([ 1, 3, 5, 7 ], 5) AS res;
Returns: 3