arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

arrayContainsString

This section contains reference documentation for the arrayContainsString function.

Checks if string value exists in array.

hashtag
Signature

arrayContainsString('colName', valueToFind)

hashtag
Usage Examples

These examples are based on the .

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

N7713A,N7713A

true

N344AA,N344AA

false

N7713A,N7713A

true

Hybrid Quick Start