This section contains reference documentation for the arrayIndexOfString function.
Was this helpful?
Finds the last index of the given value in the array starting at the given index.
arrayIndexOfString('colName', valueToFind)
These examples are based on the .
select DivTailNums, arrayIndexOfString(DivTailNums, 'N7713A') AS index from airlineStats WHERE arraylength(DivTailNums) >= 2 limit 5
N7713A,N7713A
0
N344AA,N344AA
-1