FunctionsJSON

json_extract_string

Extracts the JSON value at the given path and returns it as a string. If the path is missing, the JSON is invalid, or the value is not a JSON string, the result is NULL.

json_extract_string(…) → String

Kind · scalar

Extracts the JSON value at the given path and returns it as a string. If the path is missing, the JSON is invalid, or the value is not a JSON string, the result is NULL.

Part of the JSON family.

json_extract_raw

Extracts a JSON fragment and returns the raw JSON token without scalar coercion.

json_extract_uint

Extracts the JSON value at the given path and returns it as an unsigned integer. If the path is missing, the JSON is invalid, or the value is negative/not an integer/overflows, the result is NULL.