ARRAY_CONCAT
Combines one or more arrays that are passed as arguments.
Syntax
ARRAY_CONCAT(<arr1> [, ...n])
| Parameter | Description |
<arr> [, ...n] | The arrays to be combined. If only one array is given, an identical array is returned. |
Example
SELECT
ARRAY_CONCAT([ 1, 2, 3, 4 ], [ 5, 6, 7, 8 ]) AS res;