JSON_PATH function
Allows navigation and retrieval of specific data from JSON objects or arrays based on a specified path or query.
Syntax
json_path(<val>, <path>)
| Parameter | Type | Description |
|---|---|---|
| val | string | |
| path | string |
Usages
json_path(`meta_fields`, "collection.name")
json_path(`shipping_address`, "country")