JSON_ELEMENT

Syntax

JSON_ELEMENT(<string>; <number>)

Description

Returns the given element of a JSON arrayThe first element of a JSON array is numbered 0.

Examples

Column1NumberJSON_ELEMENT returns
[a,b,null]0a
[a,b,null]0.0a
[a,b,null]1b
[a,b,null]2null