W3cubDocs

/MariaDB

JSON Functions

MariaDB starting with 10.2.3

Functions relating to JSON, such as JSON_VALUE, JSON_ARRAY etc.

Title Description
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_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_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.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/json-functions/