Below is a list of the JSON functions and operators available in MySQL.
Name | Description |
---|---|
-> | Inline path operator that returns a value from a JSON column after evaluating the path. Equivalent to JSON_EXTRACT() . |
->> | Same as the -> operator except that it unquotes the value. |
JSON_ARRAY() | Creates a JSON array. |
JSON_ARRAYAGG() | Aggregates a result set as a single JSON array. |
JSON_ARRAY_APPEND() | Appends data to a JSON document. |
JSON_ARRAY_INSERT() | Inserts a new value into a JSON array. |
JSON_CONTAINS() | Tests whether or not a specified value is found in the given JSON document or, optionally, at the specified path within the document. |
JSON_CONTAINS_PATH() | Tests whether or not a specified path is found in the given JSON document. |
JSON_DEPTH() | Returns the maximum depth of a JSON document. |
JSON_EXTRACT() | Returns data from a JSON document. The actual data returned is determined by the path you provide as an argument. |
JSON_INSERT() | Inserts a value into a JSON document and returns the result. |
JSON_KEYS() | Returns keys from the top level value of a JSON object. |
JSON_LENGTH() | Returns the length of a JSON document. |
JSON_MERGE() | Merges JSON documents, preserving duplicate keys. Deprecated synonym for JSON_MERGE_PRESERVE() . |
JSON_MERGE_PATCH() | Performs an RFC 7396 compliant merge of two or more JSON documents, without preserving members having duplicate keys. |
JSON_MERGE_PRESERVE() | Merges JSON documents, while preserving duplicate keys. Synonym for (the deprecated) JSON_MERGE() . |
JSON_OBJECT() | Creates a JSON object from a list of key/value pairs. |
JSON_OBJECTAGG() | Aggregates a result set as a single JSON array whose elements consist of the rows. |
JSON_OVERLAPS() | Compares two JSON documents, returns true (1 ) if these have any key-value pairs or array elements in common, otherwise it returns false (0 ). |
JSON_PRETTY() | Prints a JSON document in human-readable format. |
JSON_QUOTE() | Quotes a string as a JSON value by wrapping it with double quote characters and escaping interior quote and other characters, then returning the result as a utf8mb4 string. Typically used to produce a valid JSON string literal for inclusion within a JSON document. |
JSON_REMOVE() | Removes data from a JSON document. |
JSON_REPLACE() | Replaces values in JSON document. |
JSON_SCHEMA_VALID() | Validates a JSON document against a JSON schema and returns TRUE/1 if the document is valid, FALSE/0 if it is not. |
JSON_SCHEMA_VALIDATION_REPORT() | Validates a JSON document against a JSON schema and returns a report in JSON format on outcome of the validation including success or failure and reasons for failure. |
JSON_SEARCH() | Returns the path to a given string in a JSON document. |
JSON_SET() | Inserts or updates values in a JSON document and returns the result. |
JSON_STORAGE_FREE() | Shows how much storage space was freed up after a JSON Document was updated. |
JSON_STORAGE_SIZE() | Returns the number of bytes used to store the binary representation of a JSON document. |
JSON_TABLE() | Converts JSON data into a relational form. |
JSON_TYPE() | Returns the type of a JSON value. |
JSON_UNQUOTE() | Removes quotes from a JSON value. |
JSON_VALID() | Tests whether a value is valid JSON. |
JSON_VALUE() | Extracts a value from JSON document at location pointed to by the path provided. |
MEMBER OF() | Tests whether or not a value is a member of a given JSON array. Returns true ( 1 ) if the array contains the value, and false (0 ) if it doesn’t. |