JSON_EXTRACT

Purpose

This function extracts one or more SQL values from a valid JSON string. For each SQL value, JSON_EXTRACT requires a JSON path expression that specifies the value to extract.

Syntax

json_extract::=

json_extract_1

json_extract_2

json_input_clause::=

json_input_clause