# BSON\_ARRAY\_CONTAINS\_BSON

Returns a SingleStore `TINYINT` 1 if the specified value is present in the BSON array.

## Syntax

```
BSON_ARRAY_CONTAINS_BSON(<array>, <value>)
```

## Arguments

* `<array>`: A BSON array or an expression that evaluates to a valid BSON array.
* `<value>`: The value to find in the array.

## Return Type

SingleStore `TINYINT` type.

## Remarks

* If the specified `<array>` argument is not a valid BSON array, returns `NULL`.
* If the specified `<array>` argument is SQL `NULL`, returns 0.
* If the specified `<value>` is present in the `<array>`, returns 1, otherwise 0.

## Examples

**Note**: The following examples explicitly cast string to BSON for clarity.

```sql
SELECT BSON_ARRAY_CONTAINS_BSON('[true,"abc",123]':>BSON, '123':>BSON) AS Result; 

```

```output

+--------+
| Result |
+--------+
|      1 |
+--------+
```

```sql
SELECT BSON_ARRAY_CONTAINS_BSON('[{"a":1,"b":2},"abc",123]':>BSON, '{"b":1,"a":2}':>BSON) AS Result; 

```

```output

+--------+
| Result |
+--------+
|      0 |
+--------+
```

```sql
SELECT BSON_ARRAY_CONTAINS_BSON('{"a":12,"b":23}':>BSON, '123':>BSON) AS Result;

```

```output

+--------+
| Result |
+--------+
|   NULL |
+--------+
```

***

Modified at: April 3, 2024

Source: [/cloud/reference/sql-reference/bson-functions/bson-array-contains-bson/](https://docs.singlestore.com/cloud/reference/sql-reference/bson-functions/bson-array-contains-bson/)

(An index of the documentation is available at /llms.txt)