Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
executable file 33 lines (29 sloc) 2.77 KB
title category
JSON Functions
user guide

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))
You can’t perform that action at this time.