# JSON\_ARRAY\_CONTAINS\_\<type>

This is a set of three JSON functions, which return true if the given value is contained in the JSON array.

JSON arrays are lists in this form:

```sql
["alpha", "beta", "gamma"]
["alpha", 1, 2, 3]

```

* `JSON_ARRAY_CONTAINS_DOUBLE` is for all numeric data. Javascript has only one numeric type.
* `JSON_ARRAY_CONTAINS_STRING` is for all text and binary types.
* `JSON_ARRAY_CONTAINS_JSON` is for all valid Javascript types, including `true`, `false`, JSON maps, and lists.

```sql
JSON_ARRAY_CONTAINS_<type>(json, value)

```

## Arguments

* `json`: a valid JSON array, or the name of a JSON column.
* `value`: the value to search.

**Return Value**

* 1 (SQL TRUE) if the given JSON array contains a top-level element comparing equal to the specified value.
* 0 (SQL FALSE) if the specified value is not present, or if the specified value is SQL NULL.
* SQL NULL if json is not a valid JSON array.

## Examples

```sql
SELECT JSON_ARRAY_CONTAINS_STRING('["alpha", "beta", "gamma", "delta"]', 'delta') AS has_delta;


```

```output

+-----------+
| has_delta |
+-----------+
|         1 |
+-----------+

```

```sql
SELECT JSON_ARRAY_CONTAINS_STRING('beta', 'delta') AS has_alpha;


```

```output

+-----------+
| has_alpha |
+-----------+
|         0 |
+-----------+
```

```sql
SELECT JSON_ARRAY_CONTAINS_STRING('1', 'delta') AS has_delta;


```

```output

+-----------+
| has_delta |
+-----------+
|      NULL |
+-----------+
```

```sql
SELECT JSON_ARRAY_CONTAINS_DOUBLE('["delta", 1, 2, 3]', 2) AS has_three;


```

```output

+-----------+
| has_three |
+-----------+
|         1 |
+-----------+
```

```sql
SELECT JSON_ARRAY_CONTAINS_JSON('["delta", 1, true, 3]', 'true') AS is_truth;

```

```output

+----------+
| is_truth |
+----------+
|        1 |
+----------+
```

```sql
SELECT JSON_ARRAY_CONTAINS_JSON('["letter", {"alpha":"beta"}, 4]', '{"alpha":"beta"}') AS has_map;


```

```output

+---------+
| has_map |
+---------+
|       1 |
+---------+
```

***

Modified at: March 7, 2023

Source: [/db/v9.1/reference/sql-reference/json-functions/json-array-contains-type/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/json-functions/json-array-contains-type/)

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