HeatWave Release Notes
JSON functions are supported as of MySQL 8.2.0-u1.
Table 2.8 JSON Functions
| Name | Description |
|---|---|
-> |
Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). |
->> |
Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). |
JSON_ARRAY() |
Create JSON array |
JSON_DEPTH() |
Maximum depth of JSON document |
JSON_EXTRACT() |
Return data from JSON document |
JSON_LENGTH() |
Number of elements in JSON document |
JSON_OBJECT() |
Create JSON object |
JSON_UNQUOTE() |
Unquote JSON value |