{"id":18499,"date":"2021-07-29T08:03:39","date_gmt":"2021-07-28T22:03:39","guid":{"rendered":"https:\/\/database.guide\/?p=18499"},"modified":"2021-07-29T08:03:39","modified_gmt":"2021-07-28T22:03:39","slug":"mariadb-json-functions","status":"publish","type":"post","link":"https:\/\/database.guide\/mariadb-json-functions\/","title":{"rendered":"MariaDB JSON Functions"},"content":{"rendered":"\n

Below is a list of the JSON functions available in MariaDB.<\/p>\n\n\n\n\n\n\n\n

Name<\/th>Description<\/th><\/tr><\/thead>
JSON_ARRAY()<\/a><\/code><\/td>Create JSON array<\/td><\/tr>
JSON_ARRAYAGG()<\/a><\/code><\/td>Returns a JSON array containing an element for each value in a given set of JSON or SQL values.<\/td><\/tr>
JSON_ARRAY_APPEND()<\/a><\/code><\/td>Append data to JSON document<\/td><\/tr>
JSON_ARRAY_INSERT()<\/a><\/code><\/td>Insert into JSON array<\/td><\/tr>
JSON_COMPACT()<\/a><\/code><\/td>Removes all unnecessary spaces from a JSON document, so that it\u2019s as short and compact as possible, and returns the result.<\/td><\/tr>
JSON_CONTAINS()<\/a><\/code><\/td>Whether JSON document contains specific object at path<\/td><\/tr>
JSON_CONTAINS_PATH()<\/a><\/code><\/td>Whether JSON document contains any data at path<\/td><\/tr>
JSON_DEPTH()<\/a><\/code><\/td>Maximum depth of JSON document<\/td><\/tr>
JSON_DETAILED()<\/a><\/code><\/td>Print a JSON document in human-readable format<\/td><\/tr>
JSON_EXISTS()<\/a><\/code><\/td>Determines whether a value exists at the specified path in the given JSON data.<\/td><\/tr>
JSON_EXTRACT()<\/a><\/code><\/td>Return data from JSON document<\/td><\/tr>
JSON_INSERT()<\/a><\/code><\/td>Insert data into JSON document<\/td><\/tr>
JSON_KEYS()<\/a><\/code><\/td>Array of keys from JSON document<\/td><\/tr>
JSON_LENGTH()<\/a><\/code><\/td>Number of elements in JSON document<\/td><\/tr>
JSON_LOOSE()<\/a><\/code><\/td>Adds spaces to a JSON document to make it more readable for humans.<\/td><\/tr>
JSON_MERGE()<\/a><\/code><\/td>Merge JSON documents, preserving duplicate keys. Deprecated.<\/td><\/tr>
JSON_MERGE_PATCH()<\/a><\/code><\/td>Merge JSON documents, replacing values of duplicate keys<\/td><\/tr>
JSON_MERGE_PRESERVE()<\/a><\/code><\/td>Merge JSON documents, preserving duplicate keys. Synonym for the deprecated JSON_MERGE()<\/code>.<\/td><\/tr>
JSON_OBJECT()<\/a><\/code><\/td>Create JSON object<\/td><\/tr>
JSON_OBJECTAGG()<\/a><\/code><\/td>Returns a JSON object containing key-value pairs, based on its two arguments.<\/td><\/tr>
JSON_QUERY()<\/a><\/code><\/td>Returns an object or array from a JSON document, based on the path provided.<\/td><\/tr>
JSON_QUOTE()<\/a><\/code><\/td>Quote JSON document<\/td><\/tr>
JSON_REMOVE()<\/a><\/code><\/td>Remove data from JSON document<\/td><\/tr>
JSON_REPLACE()<\/a><\/code><\/td>Replace values in JSON document<\/td><\/tr>
JSON_SEARCH()<\/a><\/code><\/td>Path to value within JSON document<\/td><\/tr>
JSON_SET()<\/a><\/code><\/td>Insert data into JSON document<\/td><\/tr>
JSON_TABLE()<\/a><\/code><\/td>Return data from a JSON expression as a relational table<\/td><\/tr>
JSON_TYPE()<\/a><\/code><\/td>Type of JSON value<\/td><\/tr>
JSON_UNQUOTE()<\/a><\/code><\/td>Unquote JSON value<\/td><\/tr>
JSON_VALID()<\/a><\/code><\/td>Whether JSON value is valid<\/td><\/tr>
JSON_VALUE()<\/a><\/code><\/td>Extract value from JSON document at location pointed to by the path provided.<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

Below is a list of the JSON functions available in MariaDB.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[117],"tags":[93,80],"class_list":["post-18499","post","type-post","status-publish","format-standard","hentry","category-mariadb","tag-functions","tag-json"],"_links":{"self":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/18499","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/comments?post=18499"}],"version-history":[{"count":6,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/18499\/revisions"}],"predecessor-version":[{"id":18851,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/18499\/revisions\/18851"}],"wp:attachment":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/media?parent=18499"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/categories?post=18499"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/tags?post=18499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}