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