DB
FunctionsJSON

json_extract_int

Extracts the JSON value at the given path and returns it as a signed integer. If the path is missing, the JSON is invalid, or the value is not an integer (or overflows the target type), the result …

json_extract_int(…) → Int64

Kind · scalar

Extracts the JSON value at the given path and returns it as a signed integer. If the path is missing, the JSON is invalid, or the value is not an integer (or overflows the target type), the result is NULL.

Part of the JSON family.

json_extract_float

Extracts the JSON value at the given path and returns it as a floating-point number. If the path is missing, the JSON is invalid, or the value is not numeric, the result is NULL.

json_extract_keys

Returns the top-level keys of the selected JSON object as a JSON string array.