The JSON functions are listed in the following table −
| S.No. | Function & Description |
|---|---|
| 1 | json_extract_path_text(js on text, json_path text)Extracts JSON string from a JSON string based on json path specified. |
| 2 | json_array_get(json_array text, index int4)Returns the element at the specified index into the JSON array. |
| 3 | json_array_contains(json_ array text, value any)Determine if the given value exists in the JSON array. |
| 4 | json_array_length(json_ar ray text)Returns the length of json array. |