arrayIndexOfString
This section contains reference documentation for the arrayIndexOfString function.
Finds the last index of the given value in the array starting at the given index.
arrayIndexOfString('colName', valueToFind)
select DivTailNums,
arrayIndexOfString(DivTailNums, 'N7713A') AS index
from airlineStats
WHERE arraylength(DivTailNums) >= 2
limit 5
DivTailNums | index |
---|---|
N7713A,N7713A | 0 |
N344AA,N344AA | -1 |
N7713A,N7713A | 0 |
Last modified 1yr ago