This section contains reference documentation for the arrayContainsString function.
Last updated 2 years ago
Was this helpful?
Checks if string value exists in array.
arrayContainsString('colName', valueToFind)
These examples are based on the .
select DivTailNums, arrayContainsString(DivTailNums, 'N7713A') AS index from airlineStats WHERE arraylength(DivTailNums) >= 2 limit 5
N7713A,N7713A
true
N344AA,N344AA
false