array_position

SinceVersion 1.2.0

array_position

description

Syntax

BIGINT array_position(ARRAY<T> arr, T value)

Returns a position/index of first occurrence of the value in the given array.

  1. position - value position in array (starts with 1);
  2. 0 - if value does not present in the array;
  3. NULL - when array is NULL.

notice

Only supported in vectorized engine

example

  1. mysql> set enable_vectorized_engine=true;
  2. mysql> SELECT id,c_array,array_position(c_array, 5) FROM `array_test`;
  3. +------+-----------------+------------------------------+
  4. | id | c_array | array_position(`c_array`, 5) |
  5. +------+-----------------+------------------------------+
  6. | 1 | [1, 2, 3, 4, 5] | 5 |
  7. | 2 | [6, 7, 8] | 0 |
  8. | 3 | [] | 0 |
  9. | 4 | NULL | NULL |
  10. +------+-----------------+------------------------------+
  11. mysql> select array_position([1, null], null);
  12. +--------------------------------------+
  13. | array_position(ARRAY(1, NULL), NULL) |
  14. +--------------------------------------+
  15. | 2 |
  16. +--------------------------------------+
  17. 1 row in set (0.01 sec)

keywords

ARRAY,POSITION,ARRAY_POSITION