JSON_COUNT
The JSONCOUNT function returns the number of items in a JSON array
Syntax
JSON_COUNT(json, jsonpath)
Example
The following example returns the number of items in the JSON array.
SELECT JSON_COUNT(JSON_ARRAY(1, 2, 3),'$') json
FROM /shared/examples/ds_orders/tutorial/customers
WHERE customerid = 10
Result: 3