FunctionsJSON

json_extract_array

Extracts an array value from the provided JSON path and returns it as a JSON array token.

json_extract_array(…) → JSON

Kind · scalar

Extracts an array value from the provided JSON path and returns it as a JSON array token.

Part of the JSON family.

json_extract

Extracts the JSON value at the provided path and returns it as a JSON token.

json_extract_array_raw

Extracts and returns the raw JSON array fragment from the selected path.