Syntax
JSON_ELEMENT(<string>; <number>)
Description
Returns the given element of a JSON array. The first element of a JSON array is numbered 0.
Examples
| Column1 | Number | JSON_ELEMENT returns |
|---|---|---|
| [a,b,null] | 0 | a |
| [a,b,null] | 0.0 | a |
| [a,b,null] | 1 | b |
| [a,b,null] | 2 | null |
Further Documentation
Find more documentation on working with JSON here.