json_array

Description

Syntax

VARCHAR json_array(VARCHAR,...)

Generate a json array containing the specified values, return empty if no values

example

  1. MySQL> select json_array();
  2. +--------------+
  3. | json_array() |
  4. +--------------+
  5. | []           |
  6. +--------------+
  8. MySQL> select json_array(null);
  9. +--------------------+
  10. | json_array('NULL') |
  11. +--------------------+
  12. | [NULL]             |
  13. +--------------------+
  16. MySQL> SELECT json_array(1, "abc", NULL, TRUE, CURTIME());
  17. +-----------------------------------------------+
  18. | json_array(1, 'abc', 'NULL', TRUE, curtime()) |
  19. +-----------------------------------------------+
  20. | [1, "abc", NULL, TRUE, "10:41:15"]            |
  21. +-----------------------------------------------+
  24. MySQL> select json_array("a", null, "c");
  25. +------------------------------+
  26. | json_array('a', 'NULL', 'c') |
  27. +------------------------------+
  28. | ["a", NULL, "c"]             |
  29. +------------------------------+

keywords

json,array,json_array