array_apply

SinceVersion 1.2.3

array_apply

description

Filter array to match specific binary condition

Syntax

1. array_apply(arr, op, val)

Arguments

arr — The array to inspect. If it null, null will be returned. op — The compare operation, op includes =, >=, <=, >, <, !=. Support const value only. val — The compared value.If it null, null will be returned. Support const value only.

Returned value

The filtered array matched with condition.

Type: Array.

notice

Only supported in vectorized engine

example

1. mysql> select array_apply([1, 2, 3, 4, 5], ">=", 2);
2. +--------------------------------------------+
3. | array_apply(ARRAY(1, 2, 3, 4, 5), '>=', 2) |
4. +--------------------------------------------+
5. | [2, 3, 4, 5]                               |
6. +--------------------------------------------+
7. 1 row in set (0.01 sec)

9. mysql> select array_apply([1000000, 1000001, 1000002], "=", "1000002");
10. +-------------------------------------------------------------+
11. | array_apply(ARRAY(1000000, 1000001, 1000002), '=', 1000002) |
12. +-------------------------------------------------------------+
13. | [1000002]                                                   |
14. +-------------------------------------------------------------+
15. 1 row in set (0.01 sec)

keywords

ARRAY,APPLY,ARRAY_APPLY