element_at

Description

Returns the element at the specified position (index) from a given array. If any parameter is NULL or if the position does not exist, the result is NULL.

This function is the alias of the subscript operator [].

If you want to retrieve a value from a key-value pair in a map, see element_at.

Syntax

element_at(any_array, position)

Parameters

• any_array: an array expression from which to retrieve elements.
• position: the position of the element in the array. It must be a positive integer. Value range: [1, array length]. If position does not exist, NULL is returned.

Examples

mysql> select element_at([2,3,11],3);
+-----------------------+
|  element_at([11,2,3]) |
+-----------------------+
|                     11 |
+-----------------------+
1 row in set (0.00 sec)

keyword

ELEMENT_AT, ARRAY