| title | summary | category |
|---|---|---|
JSON Functions |
Learn about JSON functions. |
user guide |
| 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)) |