arrayContainsString
This section contains reference documentation for the arrayContainsString function.
Checks if string value exists in array.
arrayContainsString('colName', valueToFind)
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 |
Last modified 1yr ago