JSON_LEN

The JSON_LEN function returns the number of elements in an element of type array inside a JSON document. NULL is returned if an element is not an array.

Read syntax diagramSkip visual syntax diagram JSON_LEN ( json-value , search-string )

The schema is SYSTOOLS.

json-value
A BLOB column of a base table. The json-value must contain a BSON representation of a JSON document.
search-string
A path-qualified JSON field name.

The result of the function is either null value or an integer.

If the search-string is not an array, this function returns a null value, otherwise it gives you the number of values in the array.