JSON_ARRAY
json_array
Description
Syntax
VARCHAR json_array(VARCHAR,...)
Generate a json array containing the specified values, return empty if no values
example
MySQL> select json_array();
+--------------+
| json_array() |
+--------------+
| [] |
+--------------+
MySQL> select json_array(null);
+--------------------+
| json_array('NULL') |
+--------------------+
| [NULL] |
+--------------------+
MySQL> SELECT json_array(1, "abc", NULL, TRUE, CURTIME());
+-----------------------------------------------+
| json_array(1, 'abc', 'NULL', TRUE, curtime()) |
+-----------------------------------------------+
| [1, "abc", NULL, TRUE, "10:41:15"] |
+-----------------------------------------------+
MySQL> select json_array("a", null, "c");
+------------------------------+
| json_array('a', 'NULL', 'c') |
+------------------------------+
| ["a", NULL, "c"] |
+------------------------------+
keywords
json,array,json_array