MariaDB JSON Function List

The following table links to SQLiz MariaDB JSON function references. It covers functions documented on this site, not the complete server catalog; see MariaDB’s official JSON function reference for the full list.

For MariaDB’s SQL IS JSON predicate, see the operator reference.

JSON functions	Describe
`JSON_ARRAY()`	Create JSON array
`JSON_ARRAYAGG()`	Returns a JSON array containing an element for each value in a given set of JSON or SQL values.
`JSON_ARRAY_INTERSECT()`	Return items present in both JSON arrays (MariaDB 11.2+)
`JSON_ARRAY_APPEND()`	Append data to JSON document
`JSON_ARRAY_INSERT()`	Insert into JSON array
`JSON_COMPACT()`	Removes all unnecessary whitespace from a JSON document, making it as short and compact as possible, and returns the result.
`JSON_CONTAINS()`	Whether the JSON document contains a specific object at the path
`JSON_CONTAINS_PATH()`	Whether the JSON document contains any data at the path
`JSON_DEPTH()`	Maximum depth of JSON documents
`JSON_EQUALS()`	Compare JSON objects by value (MariaDB 10.7+)
`JSON_DETAILED()`	Print JSON documents in human readable format
`JSON_EXISTS()`	Determines whether a value exists at the specified path in the given JSON data.
`JSON_EXTRACT()`	Return data from a JSON document
`JSON_INSERT()`	Insert data into JSON document
`JSON_KEYS()`	An array of keys from the JSON document
`JSON_KEY_VALUE()`	Extract key-value pairs as objects (MariaDB 11.2+)
`JSON_LENGTH()`	The number of elements in the JSON document
`JSON_LOOSE()`	Adds whitespace to JSON documents to make them easier for humans to read.
`JSON_MERGE()`	Deprecated; use `JSON_MERGE_PRESERVE()` to preserve keys and values.
`JSON_MERGE_PATCH()`	Merge JSON documents, replacing values for duplicate keys
`JSON_MERGE_PRESERVE()`	Merge JSON documents, preserving duplicate keys. Synonym for the deprecated `JSON_MERGE()`.
`JSON_NORMALIZE()`	Recursively sort keys and remove whitespace for normalized JSON text (MariaDB 10.7+)
`JSON_OBJECT()`	Create JSON object
`JSON_OBJECTAGG()`	Returns a JSON object containing key-value pairs based on its two arguments.
`JSON_OBJECT_FILTER_KEYS()`	Keep object members whose keys appear in a string array (MariaDB 11.2+)
`JSON_OBJECT_TO_ARRAY()`	Convert objects into arrays of key-value pairs (MariaDB 11.2+)
`JSON_OVERLAPS()`	Check whether JSON documents share any common values (MariaDB 10.9+)
`JSON_PRETTY()`	Alias for `JSON_DETAILED()` in selected MariaDB releases
`JSON_QUERY()`	Returns an object or array from a JSON document based on the provided path.
`JSON_QUOTE()`	Quoting a JSON document
`JSON_REMOVE()`	Remove data from JSON document
`JSON_REPLACE()`	Replace values in JSON documents
`JSON_SCHEMA_VALID()`	Validate a JSON document against JSON Schema Draft 2020 (MariaDB 11.1+)
`JSON_SEARCH()`	The path to the value in the JSON document
`JSON_SET()`	Insert data into JSON document
`JSON_TABLE()`	Return data from a JSON expression as a relational table
`JSON_TYPE()`	Types of JSON values
`JSON_UNQUOTE()`	Unquoted JSON value
`JSON_VALID()`	Is the JSON value valid
`JSON_VALUE()`	Extracts the value from the JSON document at the location pointed to by the provided path.

On this page