1
MariaDB starting with 10.2.3
Functions relating to JSON, such as JSON_VALUE, JSON_ARRAY etc.
-
Differences between JSON_QUERY and JSON_VALUE
Comparison between and examples with JSON_QUERY and JSON_VALUE -
JSON_ARRAY
Returns a JSON array containing the listed values -
JSON_ARRAY_APPEND
Appends values to the end of the given arrays within a JSON document -
JSON_ARRAY_INSERT
Inserts a value into a JSON document -
JSON_COMPACT
Removes all unnecessary spaces so the json document is as short as possible -
JSON_CONTAINS
Whether a value is found in a given JSON document or at a specified path within the document -
JSON_CONTAINS_PATH
Indicates whether the given JSON document contains data at the specified path or paths -
JSON_DEPTH
Maximum depth of a JSON document -
JSON_DETAILED
Represents JSON in the most understandable way emphasizing nested structures -
JSON_EXISTS
Determines whether a specified JSON value exists in the given data -
JSON_EXTRACT
Extracts data from a JSON document -
JSON_INSERT
Inserts data into a JSON document -
JSON_KEYS
Returns keys from top-level value of a JSON object or top-level keys from the path -
JSON_LENGTH
Returns the length of a JSON document, or the length of a value within the document -
JSON_LOOSE
Adds spaces to a JSON document to make it look more readable -
JSON_MERGE
Merges the given JSON documents -
JSON_OBJECT
Returns a JSON object containing the given key/value pairs -
JSON_QUERY
Given a JSON document, returns an object or array specified by the path -
JSON_QUOTE
Quotes a string as a JSON value -
JSON_REMOVE
Removes data from a JSON document -
JSON_REPLACE
Replaces existing values in a JSON document -
JSON_SEARCH
Returns the path to the given string within a JSON document -
JSON_SET
Updates or inserts data into a JSON document -
JSON_TYPE
Returns the type of a JSON value -
JSON_UNQUOTE
Unquotes a JSON value, returning a string -
JSON_VALID
Whether a value is a valid JSON document or not -
JSON_VALUE
Given a JSON document, returns the specified scalar
