JSON_EXTRACT_PATH
9min
In this article, you will learn about the JSON_EXTRACT_PATH() function to extract the JSON sub-object.
Overview
JSON_EXTRACT_PATH() function extracts JSON nested value from a specified path.
Syntax
The syntax of the JSON_EXTRACT_PATH() function can be seen below.
Syntax
|
- from_json: the JSON value from which to extract.
- path: the path to extract.
Another Option
Besides the syntax above, Oxla provides and supports the use of operators in queries. See the syntax below:
Syntax
|
- 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.
Examples
These examples display how JSON_EXTRACT_PATH() extracts the "oxla" JSON sub-object from the specified path.
1) Use the below query:
Json extract path
|
or
Another option
|
The query above will return the following result.
Output
|
2) Run the query below:
Json extract path
|
You will get the following output:
Output
|

Updated 11 May 2023
Did this page help you?
Yes
No