JSON_EXTRACT_PATH_TEXT()
function extracts JSON nested value from a specified JSON value according to the defined path.
JSON_EXTRACT_PATH()
. This function returns a value of type text instead of type JSON.JSON_EXTRACT_PATH_TEXT()
syntax is shown below:
from_json
: the JSON value to extract.path
: the path to extract.from_json
: the JSON value from which to extract.::JSON
: a symbol that casts the text literal to a JSON type.path
: key of the field that we want to extract.JSON_EXTRACT_PATH_TEXT()
function to extract values from a JSON object at a specified index.JSON\_EXTRACT\_PATH\_TEXT()
function extracts the values and returns the output below: