Skip to main content
Version: 2.5

json_array

Description​

Converts each element of an SQL array to a JSON value and returns a JSON array that consists of the JSON values.

Syntax​

json_array(value, ...)

Parameters​

value: an element in the SQL array. Only NULL values and the following data types are supported: STRING, VARCHAR, CHAR, JSON, TINYINT, SMALLINT, INT, BIGINT, LARGEINT, DOUBLE, FLOAT, and BOOLEAN.

Return value​

Returns a JSON array.

Examples​

Example 1: Construct a JSON array that consists of values of different data types.

mysql> SELECT json_array(1, true, 'starrocks', 1.1);

       -> [1, true, "starrocks", 1.1]

Example 2: Construct an empty JSON array.

mysql> SELECT json_array();

       -> []