﻿---
title: ES|QL MV_INTERSECTS function
description: 
url: https://www.elastic.co/elastic/docs-builder/docs/2948/reference/query-languages/esql/functions-operators/mv-functions/mv_intersects
products:
  - Elasticsearch
---

# ES|QL MV_INTERSECTS function
<applies-to>
  - Elastic Stack: Preview since 9.3
</applies-to>


## Syntax

![Embedded](https://www.elastic.co/elastic/docs-builder/docs/2948/reference/query-languages/esql/images/functions/mv_intersects.svg)


## Parameters

<definitions>
  <definition term="field1">
    Expression that can be null, a single value, or multiple values.
  </definition>
  <definition term="field2">
    Expression that can be null, a single value, or multiple values.
  </definition>
</definitions>


## Description

Checks if any value yielded by the second multivalue expression is present in the values yielded by the first multivalue expression. Returns a boolean. Null values are treated as an empty set.

## Supported types


| field1          | field2          | result  |
|-----------------|-----------------|---------|
| boolean         | boolean         | boolean |
| cartesian_point | cartesian_point | boolean |
| cartesian_shape | cartesian_shape | boolean |
| date            | date            | boolean |
| date_nanos      | date_nanos      | boolean |
| double          | double          | boolean |
| geo_point       | geo_point       | boolean |
| geo_shape       | geo_shape       | boolean |
| geohash         | geohash         | boolean |
| geohex          | geohex          | boolean |
| geotile         | geotile         | boolean |
| integer         | integer         | boolean |
| ip              | ip              | boolean |
| keyword         | keyword         | boolean |
| keyword         | text            | boolean |
| long            | long            | boolean |
| text            | keyword         | boolean |
| text            | text            | boolean |
| unsigned_long   | unsigned_long   | boolean |
| version         | version         | boolean |


## Examples

```esql
ROW set = ["a", "b", "c"], element = "a"
| EVAL set_intersects_element = mv_intersects(set, element)
```


| set:keyword | element:keyword | set_intersects_element:boolean |
|-------------|-----------------|--------------------------------|
| [a, b, c]   | a               | true                           |

```esql
ROW setA = ["a","c"], setB = ["a", "b", "c"]
| EVAL a_intersects_b = mv_intersects(setB, setA)
| EVAL b_intersects_a = mv_intersects(setA, setB)
```


| setA:keyword | setB:keyword | a_intersects_b:boolean | b_intersects_a:boolean |
|--------------|--------------|------------------------|------------------------|
| [a, c]       | [a, b, c]    | true                   | true                   |

```esql
FROM airports
| WHERE mv_intersects(type, ["major"]) AND scalerank == 9
| KEEP scalerank, name, country
| SORT country
```


| scalerank:integer | name:text        | country:keyword |
|-------------------|------------------|-----------------|
| 9                 | Chandigarh Int'l | India           |
| 9                 | Cheongju Int'l   | South Korea     |