GetJSONFromWrapperOrCoercibleString takes a valid argument for JSON functions (either a JSON wrapper type or a string) and unwraps the JSON, or coerces the string into JSON.

NewJSONArray creates a new JSONArray function.

NewJSONArrayAppend creates a new JSONArrayAppend function.

NewJSONArrayInsert creates a new JSONArrayInsert function.

NewJSONContains creates a new JSONContains function.

NewJSONContainsPath creates a new JSONContainsPath function.

NewJSONDepth creates a new JSONDepth function.

NewJSONExtract creates a new JSONExtract UDF.

NewJSONInsert creates a new JSONInsert function.

NewJSONKeys creates a new JSONKeys function.

NewJsonLength creates a new JsonLength UDF.

NewJSONMergePatch creates a new JSONMergePatch function.

NewJSONMergePreserve creates a new JSONMergePreserve function.

NewJSONObject creates a new JSONObject function.

NewJSONOverlaps creates a new JSONOverlaps function.

NewJSONPretty creates a new JSONPretty function.

NewJSONQuote creates a new JSONQuote UDF.

NewJSONRemove creates a new JSONRemove function.

NewJSONReplace creates a new JSONReplace function.

NewJSONSchemaValid creates a new JSONSchemaValid function.

NewJSONSchemaValidationReport creates a new JSONSchemaValidationReport function.

NewJSONSearch creates a new NewJSONSearch function.

NewJSONSet creates a new JSONSet function.

NewJSONStorageFree creates a new JSONStorageFree function.

NewJSONStorageSize creates a new JSONStorageSize function.

NewJSONTable creates a new JSONTable function.

NewJSONType creates a new JSONType function.

NewJSONUnquote creates a new JSONUnquote UDF.

NewJSONValid creates a new JSONValid function.

NewJsonValue creates a new JsonValue UDF.

ErrUnsupportedJSONFunction is returned when a unsupported JSON function is called.

JSON_ARRAY_APPEND(json_doc, path, val[, path, val] ...) JSONArrayAppend Appends values to the end of the indicated arrays within a JSON document and returns the result.

JSON_ARRAY_INSERT(json_doc, path, val[, path, val] ...) JSONArrayInsert Updates a JSON document, inserting into an array within the document and returning the modified document.

JSON_CONTAINS(target, candidate[, path]) JSONContains indicates by returning 1 or 0 whether a given candidate JSON document is contained within a target JSON document, or, if a path argument was supplied, whether the candidate is found at a specific path within the target.

JSON_CONTAINS_PATH(json_doc, one_or_all, path[, path] ...) JSONContainsPath Returns 0 or 1 to indicate whether a JSON document contains data at a given path or paths.

JSONDepth (json_doc) JSONDepth Returns the maximum depth of a JSON document.

JSON_EXTRACT(json_doc, path[, path] ...) JSONExtract extracts data from a json document using json paths.

JSON_INSERT(json_doc, path, val[, path, val] ...) JSONInsert Inserts data into a JSON document and returns the result.

JSONKeys (json_doc[, path]) JSONKeys Returns the keys from the top-level value of a JSON object as a JSON array, or, if a path argument is given, the top-level keys from the selected path.

JSON_LENGTH(json_doc [, path]) JsonLength returns the length of a JSON document, or the length of the value extracted from the specified path.

JSONMergePatch (json_doc, json_doc[, json_doc] ...) JSONMergePatch Performs an RFC 7396 compliant merge of two or more JSON documents and returns the merged result, without preserving members having duplicate keys.

JSONMergePreserve (json_doc, json_doc[, json_doc] ...) JSONMergePreserve Merges two or more JSON documents and returns the merged result.

JSONObject Evaluates a (possibly empty) list of key-value pairs and returns a JSON object containing those pairs.

JSONOverlaps (json_doc1, json_doc2) JSONOverlaps Compares two JSON documents.

JSONPretty (json_val) JSONPretty Provides pretty-printing of JSON values similar to that implemented in PHP and by other languages and database systems.

JSONQuote (string) JSONQuote Quotes a string as a JSON value by wrapping it with double quote characters and escaping interior quote and other characters, then returning the result as a utf8mb4 string.

JSON_REMOVE(json_doc, path[, path] ...) JSONRemove Removes data from a JSON document and returns the result.

JSON_REPLACE(json_doc, path, val[, path, val] ...) JSONReplace Replaces existing values in a JSON document and returns the result.

JSON_SCHEMA_VALID(schema,document) JSONSchemaValid Validates a JSON document against a JSON schema.

JSON_SCHEMA_VALIDATION_REPORT(schema,document) JSONSchemaValidationReport Validates a JSON document against a JSON schema.

JSONSearch (json_doc, one_or_all, search_str[, escape_char[, path] ...]) JSONSearch Returns the path to the given string within a JSON document.

JSON_STORAGE_FREE(json_val) JSONStorageFree For a JSON column value, this function shows how much storage space was freed in its binary representation after it was updated in place using JSON_SET(), JSON_REPLACE(), or JSON_REMOVE().

JSON_STORAGE_SIZE(json_val) JSONStorageSize This function returns the number of bytes used to store the binary representation of a JSON document.

JSON_TABLE(expr, path COLUMNS (column_list) [AS] alias) JSONTable Extracts data from a JSON document and returns it as a relational table having the specified columns.

JSONType (json_val) Returns a utf8mb4 string indicating the type of a JSON value.

JSONUnquote unquotes JSON value and returns the result as a utf8mb4 string.

JSON_VALID(val) Returns 0 or 1 to indicate whether a value is valid JSON.

JsonValue selects data from a json document using a json path and optional type coercion.