# arrayRemoveInt

Removes value from array of ints.

## Signature

> arrayRemoveInt('colName', value)

## Usage Examples

These examples are based on the [Hybrid Quick Start](https://docs.pinot.apache.org/release-0.12.1/basics/getting-started/quick-start#hybrid).

```sql
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 |