JSON_EXTRACT_RAW
Returns a string representation of the scalar or sub-object under the key indicated by <json_pointer_expression> if the key exists. If the key does not exist, returns NULL.
Syntax
JSON_EXTRACT_RAW(<json>, <json_pointer_expression>)
| Parameter | Type | Description |
|---|---|---|
<json> | TEXT | The JSON document from which the value is to be extracted. |
<json_pointer_expression> | Literal string | A JSON pointer to the location of the array in the JSON. For more information, see JSON pointer expression syntax. |
Example
For the JSON document indicated by <json_common_example> below, see JSON common example. The Returns result is based on this common example.
SELECT
JSON_EXTRACT_RAW(<json_common_example>,'/value/dyid')
Returns: 987
JSON_EXTRACT_RAW(<json_common_example>, '/value/tagIdToHits')
Returns: {"map":{"1737729":32,"1775582":35}}