JSON_EXTRACT
The JSON_EXTRACT function returns data from a JSON document, selected from the parts of the document matched by the path arguments.
Syntax
JSON_EXTRACT(json, json_path)
Example
The following example extracts the 2nd element in the json array:
SELECT JSON_EXTRACT(JSON_ARRAY(1, 2, 3),'$[2]') json
FROM /shared/examples/ds_orders/tutorial/customers
WHERE customerid = 10
Result: 2