arrayRemoveInt
This section contains reference documentation for the arrayRemoveInt function.
Removes value from array of ints.
arrayRemoveInt('colName', value)
select DivAirportIDs,
arrayRemoveInt(DivAirportIDs, 12892) AS value
from airlineStats
WHERE arraylength(DivAirportIDs) >= 2
AND arrayContainsInt(DivAirportIDs, 12892) = 1
limit 5
DivAirportIDs | value |
---|---|
13891,12892 | 13891 |
13198,12892 | 13198 |
11066,12892 | 11066 |
13198,12892 | 13198 |
13891,12892 | 13891 |
Last modified 1yr ago