Functions That Create JSON Values Name Description Introduced Deprecated JSON_TABLE() Return data from a JSON expression as a relational table JSON_TYPE() Type of JSON value JSON_UNQUOTE() Unquote JSON value JSON_VALID() Whether JSON value is valid JSON_VALUE() Extract value from JSON document at location pointed to by path provided; return this value as VARCHAR(512) or specified type 8.0.21 MEMBER OF() Returns true (1) if first operand matches any element of JSON array passed as second operand, otherwise returns false (0) 8.0.17 2346 MySQL supports two aggregate JSON functions  JSON_ARRAYAGG()  and  JSON_OBJECTAGG() . See Section 12.20, “Aggregate Functions” , for descriptions of these. MySQL also supports “pretty-printing”  of JSON values in an easy-to-read format, using the JSON_PRETTY()  function. You can see how much storage space a given JSON value takes up, and how much space remains for additional storage, using  JSON_STORAGE_SIZE()  and  JSON_STORAGE_FREE() , respectively. For complete descriptions of these functions, see Section 12.18.8, “JSON Utility Functions” . The functions listed in this section compose JSON values from component elements. Evaluates a (possibly empty) list of values and returns a JSON array containing those values. Evaluates a (possibly empty) list of key-value pairs and returns a JSON object containing those pairs. An error occurs if any key name is  NULL  or the number of arguments is odd. mysql>  SELECT JSON_OBJECT(’id’, 87, ’name’, ’carrot’); +-----------------------------------------+ | JSON_OBJECT(’id’, 87, ’name’, ’carrot’) | +-----------------------------------------+ | {"id": 87, "name": "carrot"} | +-----------------------------------------+ mysql>  SELECT JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()); +---------------------------------------------+ | JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()) | +---------------------------------------------+ | [1, "abc", null, true, "11:30:24.000000"] | +---------------------------------------------+ • JSON_OBJECT([ key ,  val [,  key ,  val ] ...]) • JSON_ARRAY([ val [,  val ] ...]) 12.18.2 Functions That Create JSON Values