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_ARRAYAGG — Returns a JSON array containing an element for each value in a given set of JSON or SQL 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_MERGE_PATCH — RFC 7396-compliant merge of the given JSON documents.
- JSON_MERGE_PRESERVE — Synonym for JSON_MERGE.
- JSON_OBJECT — Returns a JSON object containing the given key/value pairs.
- JSON_OBJECTAGG — Returns a JSON object containing 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.
- JSONPath Expressions — MariaDB JSONPath description and definition.