1 of 1

arrayContainsString

This section contains reference documentation for the arrayContainsString function.

Checks if string value exists in array.

Signature

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

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