JSON_EXTRACT_PATH()
function extracts JSON nested value from a specified path.
JSON_EXTRACT_PATH()
function can be seen below.
from_json
: the JSON value from which 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()
extracts the “oxla” JSON sub-object from the specified path.