The following table lists the available JSON Table Operators, and a description of their purpose.
Operator | Description |
---|---|
JSON_KEYS | The JSON_KEYS table operator parses a JSON instance, from either CHAR or VARCHAR input and returns a list of key names. JSON_KEYS supports both LATIN and UNICODE character sets. |
JSON_TABLE | JSON_TABLE creates a temporary table based on all, or a subset, of the data in a JSON object. |