| description |
|---|
This section contains reference documentation for the arrayContainsInt function. |
Checks if int value exists in array.
arrayContainsInt('colName', valueToFind)
These examples are based on the Hybrid Quick Start.
select DivAirportIDs,
arrayContainsInt(DivAirportIDs, 14683) AS containsValue
from airlineStats
WHERE arraylength(DivAirportIDs) >= 2
limit 5| DivAirportIDs | containsValue |
|---|---|
| 13891,12892 | false |
| 14683,14683 | true |
| 12339,12339 | false |
| 13487,13930 | false |
| 13029,11292 | false |