arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

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.

hashtag
Signature

arrayIndexOfString('colName', valueToFind)

hashtag
Usage Examples

These examples are based on the .

DivTailNums
index
select DivTailNums, 
       arrayIndexOfString(DivTailNums, 'N7713A') AS index
from airlineStats 
WHERE arraylength(DivTailNums) >= 2
limit 5

N7713A,N7713A

0

N344AA,N344AA

-1

N7713A,N7713A

0

Hybrid Quick Start