Chapter 21. JSON Data
Table of Contents
- 21.1. Extracting a Value from JSON Data (
json_extract,json_extract_string)- 21.2. Validating JSON Data (
json_valid)- 21.3. Retrieving JSON Data Type (
json_type)- 21.4. Retrieving JSON Keys (
json_keys)- 21.5. Retrieving the JSON Structure (
json_structure)- 21.6. Checking a JSON Value (
json_contains)- 21.7. Retrieving the JSON Array Length (
json_array_length)- 21.8. Transforming JSON Data (
json_transform,json_transform_strict)- 21.9. Aggregating Values into a JSON Array (
json_group_array)- 21.10. Aggregating Values into a JSON Object (
json_group_object)- 21.11. Aggregating JSON Data into a Structure (
json_group_structure)- 21.12. Parsing and Removing Whitespace from JSON Data (
json) - 21.2. Validating JSON Data (
This chapter describes stored procedures for querying and transforming JSON data.