JSON Functions

Function Name and Syntactic Sugar	Description
JSON_EXTRACT(json_doc, path[, path] …)	Return data from a JSON document, selected from the parts of the document matched by the `path` arguments
JSON_UNQUOTE(json_val)	Unquote JSON value and return the result as a `utf8mb4` string
JSON_TYPE(json_val)	Return a `utf8mb4` string indicating the type of a JSON value
JSON_SET(json_doc, path, val[, path, val] …)	Insert or update data in a JSON document and return the result
JSON_INSERT(json_doc, path, val[, path, val] …)	Insert data into a JSON document and return the result
JSON_REPLACE(json_doc, path, val[, path, val] …)	Replace existing values in a JSON document and return the result
JSON_REMOVE(json_doc, path[, path] …)	Remove data from a JSON document and return the result
JSON_MERGE(json_doc, json_doc[, json_doc] …)	Merge two or more JSON documents and return the merged result
JSON_OBJECT(key, val[, key, val] …)	Evaluate a (possibly empty) list of key-value pairs and return a JSON object containing those pairs
JSON_ARRAY([val[, val] …])	Evaluate a (possibly empty) list of values and return a JSON array containing those values
->	Return value from JSON column after evaluating path; the syntactic sugar of `JSON_EXTRACT(doc, path_literal)`
->>	Return value from JSON column after evaluating path and unquoting the result; the syntactic sugar of `JSON_UNQUOTE(JSONJSON_EXTRACT(doc, path_literal))`