Link Search Menu Expand Document

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}}