JSON_ELEMENT

Owned by Juliane Wetzel

Last updated: May 10, 2023 by Konsta Danyliuk (Deactivated)

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.