JSON_EXTRACT_SCALAR

This function Like json_extract(), but returns the result value as a string (as opposed to being encoded as JSON). The value referenced by json_path must be a scalar (boolean, number or string).

Syntax

JSON_EXTRACT_SCALAR(json, json_path)

Example

The following example extracts the 3nd element in the json array:

SELECT  JSON_EXTRACT_SCALAR(JSON_ARRAY(1, 2, 3),'$[2]') json

FROM /shared/examples/ds_orders/tutorial/customers

WHERE customerid = 10

Result: 3

Top