Skip to main content
Skip to main content

array_apply

array_apply​

SinceVersion 1.2.3

array_apply

description​

Filter array to match specific binary condition

Syntax​

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​

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

mysql> select array_apply([1000000, 1000001, 1000002], "=", "1000002");
+-------------------------------------------------------------+
| array_apply(ARRAY(1000000, 1000001, 1000002), '=', 1000002) |
+-------------------------------------------------------------+
| [1000002] |
+-------------------------------------------------------------+
1 row in set (0.01 sec)

keywords​

ARRAY,APPLY,ARRAY_APPLY