Skip to main content
Version: Latest-3.4

json_array

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

tip

All of the JSON functions and operators are listed in the navigation and on the overview page

Accelerate your queries with generated columns

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();

       -> []