 JSON Functions    
MariaDB starting with 10.2.3Functions 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. 


 JSONPath Expressions
 MariaDB JSONPath description and definition. 


 JSON_ARRAY
 Returns a JSON array containing the listed values. 


 JSON_ARRAYAGG
 Returns a JSON array containing an element for each value in a given set of JSON or SQL 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_EQUALS
 Checks if there is equality between two json objects. 


 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_NORMALIZE
 Recursively sorts keys and removes spaces, allowing comparison of json documents for equality. 


 JSON_OBJECT
 Returns a JSON object containing the given key/value pairs. 


 JSON_OBJECTAGG
 Returns a JSON object containing key-value pairs. 


 JSON_OVERLAPS
 Returns true if two json documents have at least one key-value pair or array element in common. 


 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_TABLE
 Given data from a JSON document, returns a representation of it as a relational table. 


 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.  

    
{'path': 'public/docs/mariadb/json-functions/index.html', 'source': 'DevDocs.IO'}