MariaDB JSON Functions

In MariaDB, JSON_ARRAY_APPEND() is a built-in function that appends a value to a specified array in a JSON document and returns the modified JSON document.

In MariaDB, JSON_ARRAY_INSERT() is a built-in function that inserts a value into a specified JSON array and returns a new JSON document.

In MariaDB, JSON_ARRAY() is a built-in function that returns a JSON array containing all parameters.

In MariaDB, JSON_ARRAYAGG() is a built-in function that aggregates the value of a specified column or expression into a JSON array.

In MariaDB, JSON_COMPACT() is a built-in function that removes all unnecessary spaces from a JSON document to reduce the size of the JSON document.

In MariaDB, JSON_CONTAINS_PATH() is a built-in function that checks whether a value exists at a given path in a JSON document.

In MariaDB, JSON_CONTAINS() is a built-in function that checks whether a JSON document contains another JSON document.

In MariaDB, JSON_DEPTH() is a built-in function that returns the maximum depth of a given JSON document.

In MariaDB, JSON_DETAILED() is a built-in function that formats the output of a JSON document so that it is easier to read.

In MariaDB, JSON_EXISTS() is a built-in function that checks whether a given path exists in a given JSON document.

In MariaDB, JSON_EXTRACT() is a built-in function that extracts data from a JSON document given one or more paths.

In MariaDB, JSON_INSERT() is a built-in function that inserts one or more pieces of data into a JSON document and returns the new JSON document.

In MariaDB, JSON_KEYS() is a built-in function that returns an array containing the topmost member (key) of the specified JSON object.

In MariaDB, JSON_LENGTH() is a built-in function that returns the length of a JSON document or a node within a JSON document specified by a path.

In MariaDB, JSON_LOOSE() is a built-in function that adds whitespace to JSON documents to make them more readable.

In MariaDB, JSON_MERGE_PATCH() is a built-in function that merges two or more JSON documents and returns the merged result.

In MariaDB, JSON_MERGE_PRESERVE() is a built-in function that merges two or more JSON documents and returns the result.

In MariaDB, JSON_MERGE() is a built-in function that merges two or more JSON documents and returns the result.

In MariaDB, JSON_OBJECT() is a built-in function that returns a JSON object containing all key-value pairs specified by parameters.

In MariaDB, JSON_OBJECTAGG() is a built-in function that aggregates key-value pairs with the first parameter as the key and the second parameter as the value into a JSON object.

In MariaDB, JSON_QUERY() is a built-in function that returns an object or array from a JSON document based on the provided path.

In MariaDB, JSON_QUOTE() is a built-in function that wraps a value in double quotes, making it a JSON string value.

In MariaDB, JSON_REMOVE() is a built-in function that removes the data specified by path from a JSON document.

In MariaDB, JSON_REPLACE() is a built-in function that replaces existing data in a JSON document and returns the new JSON document.

In MariaDB, JSON_SEARCH() is a built-in function that returns the path of a given value within a given JSON document.

In MariaDB, JSON_SET() is a built-in function that inserts or updates data in a JSON document and returns the new JSON document.

In MariaDB, JSON_TABLE() is a built-in function that extracts data from a specified JSON document and returns a relational table with specified columns.

In MariaDB, JSON_TYPE() is a built-in function that returns the type of a given JSON value as a string.

In MariaDB, JSON_UNQUOTE() is a built-in function that de-quotes a JSON string and returns the result as a string.

In MariaDB, JSON_VALID() is a built-in function that returns 0 and 1 to indicate whether the given argument is a valid JSON document.

In MariaDB, JSON_VALUE() is a built-in function that returns a scalar value from a JSON document based on the provided path.