| description |
|---|
This section contains reference documentation for the arrayContainsString function. |
Checks if string value exists in array.
arrayContainsString('colName', valueToFind)
These examples are based on the Hybrid Quick Start.
select DivTailNums,
arrayContainsString(DivTailNums, 'N7713A') AS index
from airlineStats
WHERE arraylength(DivTailNums) >= 2
limit 5| DivTailNums | index |
|---|---|
| N7713A,N7713A | true |
| N344AA,N344AA | false |
| N7713A,N7713A | true |