This section contains reference documentation for the arrayIndexOfString function.
Last updated 2 years ago
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