Skip to main content
Version: Stable-3.1

array_intersect

Description

Returns an array of the elements in the intersection of one or more arrays.

Syntax

array_intersect(input0, input1, ...)

Parameters

input: one or more arrays whose intersection you want to obtain. Specify arrays in the (input0, input1, ...) format and make sure that the arrays that you specify are of the same data type.

Return value

Returns an array of the same data type as the arrays that you specify.

Examples

Example 1:

mysql> SELECT array_intersect(["SQL", "storage"], ["mysql", "query", "SQL"], ["SQL"])
AS no_intersect ;
+--------------+
| no_intersect |
+--------------+
| ["SQL"] |
+--------------+

Example 2:

mysql> SELECT array_intersect(["SQL", "storage"], ["mysql", null], [null]) AS no_intersect ;
+--------------+
| no_intersect |
+--------------+
| [] |
+--------------+

Example 3:

mysql> SELECT array_intersect(["SQL", null, "storage"], ["mysql", null], [null]) AS no_intersect ;
+--------------+
| no_intersect |
+--------------+
| [null] |
+--------------+