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).Supported Signatures
Copy
function json_extract_scalar(json, jsonpath) returns varcharfunction json_extract_scalar(varchar, jsonpath) returns varchar
Like json_extract(), but returns the size of the value. For objects or arrays, the size is the number of members, and the size of a scalar value is zero.Supported Signatures
Copy
function json_size(json, jsonpath) returns bigintfunction json_size(varchar, jsonpath) returns bigint