SQL Reference
...
SQL Functions
JSON Functions
JSON_EXTRACT_PATH
7min
JSON_EXTRACT_PATH() function extracts JSON nested value from a specified path.
The syntax of the JSON_EXTRACT_PATH() function can be seen below.Ā

- from_json: the JSON value from which to extract.
- path: the path to extract.
Besides the syntax above, Oxla provides and supports the use of operators in queries. See the syntax below:

- from_json: the JSON value from which to extract.
- ::JSON: a symbol that casts the string literal to a JSON type.
- path: key of the field that we want to extract.
These examples display how JSON_EXTRACT_PATH() extracts the "oxla" JSON sub-object from the specified path.
1) Use the below query:

or

The query above will return the following result.

2) Run the query below:

You will get the following output:


Updated 09 Oct 2023

Did this page help you?