JSON_ELEMENT
- Charles Bishop (Deactivated)
Owned by Charles Bishop (Deactivated)
Jan 30, 2018
Loading data...
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 |