> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions.md).

# JSON Functions

* [JSONPath Expressions](/docs/server/reference/sql-functions/special-functions/json-functions/jsonpath-expressions.md)
* [Differences between JSON\_QUERY and JSON\_VALUE](/docs/server/reference/sql-functions/special-functions/json-functions/differences-between-json_query-and-json_value.md)
* [JSON\_ARRAY](/docs/server/reference/sql-functions/special-functions/json-functions/json_array.md)
* [JSON\_ARRAYAGG](/docs/server/reference/sql-functions/aggregate-functions/json_arrayagg.md)
* [JSON\_ARRAY\_APPEND](/docs/server/reference/sql-functions/special-functions/json-functions/json_array_append.md)
* [JSON\_ARRAY\_INSERT](/docs/server/reference/sql-functions/special-functions/json-functions/json_array_insert.md)
* [JSON\_ARRAY\_INTERSECT](/docs/server/reference/sql-functions/special-functions/json-functions/json_array_intersect.md)
* [JSON\_COMPACT](/docs/server/reference/sql-functions/special-functions/json-functions/json_compact.md)
* [JSON\_CONTAINS](/docs/server/reference/sql-functions/special-functions/json-functions/json_contains.md)
* [JSON\_CONTAINS\_PATH](/docs/server/reference/sql-functions/special-functions/json-functions/json_contains_path.md)
* [JSON\_DEPTH](/docs/server/reference/sql-functions/special-functions/json-functions/json_depth.md)
* [JSON\_DETAILED](/docs/server/reference/sql-functions/special-functions/json-functions/json_detailed.md)
* [JSON\_EQUALS](/docs/server/reference/sql-functions/special-functions/json-functions/json_equals.md)
* [JSON\_EXISTS](/docs/server/reference/sql-functions/special-functions/json-functions/json_exists.md)
* [JSON\_EXTRACT](/docs/server/reference/sql-functions/special-functions/json-functions/json_extract.md)
* [JSON\_INSERT](/docs/server/reference/sql-functions/special-functions/json-functions/json_insert.md)
* [JSON\_KEY\_VALUE](/docs/server/reference/sql-functions/special-functions/json-functions/json_key_value.md)
* [JSON\_KEYS](/docs/server/reference/sql-functions/special-functions/json-functions/json_keys.md)
* [JSON\_LENGTH](/docs/server/reference/sql-functions/special-functions/json-functions/json_length.md)
* [JSON\_LOOSE](/docs/server/reference/sql-functions/special-functions/json-functions/json_loose.md)
* [JSON\_MERGE](/docs/server/reference/sql-functions/special-functions/json-functions/json_merge.md)
* [JSON\_MERGE\_PATCH](/docs/server/reference/sql-functions/special-functions/json-functions/json_merge_patch.md)
* [JSON\_MERGE\_PRESERVE](/docs/server/reference/sql-functions/special-functions/json-functions/json_merge_preserve.md)
* [JSON\_NORMALIZE](/docs/server/reference/sql-functions/special-functions/json-functions/json_normalize.md)
* [JSON\_OBJECT](/docs/server/reference/sql-functions/special-functions/json-functions/json_object.md)
* [JSON\_OBJECT\_FILTER\_KEYS](/docs/server/reference/sql-functions/special-functions/json-functions/json_object_filter_keys.md)
* [JSON\_OBJECT\_TO\_ARRAY](/docs/server/reference/sql-functions/special-functions/json-functions/json_object_to_array.md)
* [JSON\_OBJECTAGG](/docs/server/reference/sql-functions/aggregate-functions/json_objectagg.md)
* [JSON\_OVERLAPS](/docs/server/reference/sql-functions/special-functions/json-functions/json_overlaps.md)
* [JSON\_PRETTY](/docs/server/reference/sql-functions/special-functions/json-functions/json_pretty.md)
* [JSON\_QUERY](/docs/server/reference/sql-functions/special-functions/json-functions/json_query.md)
* [JSON\_QUOTE](/docs/server/reference/sql-functions/special-functions/json-functions/json_quote.md)
* [JSON\_REMOVE](/docs/server/reference/sql-functions/special-functions/json-functions/json_remove.md)
* [JSON\_REPLACE](/docs/server/reference/sql-functions/special-functions/json-functions/json_replace.md)
* [JSON\_SCHEMA\_VALID](/docs/server/reference/sql-functions/special-functions/json-functions/json_schema_valid.md)
* [JSON\_SEARCH](/docs/server/reference/sql-functions/special-functions/json-functions/json_search.md)
* [JSON\_SET](/docs/server/reference/sql-functions/special-functions/json-functions/json_set.md)
* [JSON\_TABLE](/docs/server/reference/sql-functions/special-functions/json-functions/json_table.md)
* [JSON\_TYPE](/docs/server/reference/sql-functions/special-functions/json-functions/json_type.md)
* [JSON\_UNQUOTE](/docs/server/reference/sql-functions/special-functions/json-functions/json_unquote.md)
* [JSON\_VALID](/docs/server/reference/sql-functions/special-functions/json-functions/json_valid.md)
* [JSON\_VALUE](/docs/server/reference/sql-functions/special-functions/json-functions/json_value.md)
* [JSON Validation Function](/docs/server/reference/sql-functions/special-functions/json-functions/json-validation-function.md)