arrayRemoveString
This section contains reference documentation for the arrayRemoveString function.
Removes value from array of strings.
arrayRemoveString('colName', value)
select RandomAirports,
arrayRemoveString(RandomAirports, 'SEA') AS value
from airlineStats
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5
DivAirportIDs | value |
|---|---|
SEA,PSC | PSC |
SEA,PSC,PHX,MSY | PSC,PHX,MSY |
SEA,PSC,PHX,MSY | PSC,PHX,MSY |
SEA,PSC | PSC |
SEA,PSC | PSC |
Last modified 1yr ago