JSON_ARRAY_LENGTH

1
SELECT JSON_ARRAY_LENGTH('[1, 2, 3, 4, 5]');

1
SELECT JSON_ARRAY_LENGTH('{"items": [1, 2, 3]}', '$.items');

1
SELECT *
2
FROM orders
3
WHERE JSON_ARRAY_LENGTH(items_json, '$.items') >= 3;

1
SELECT
2
  AVG(JSON_ARRAY_LENGTH(tags)) as avg_tags,
3
  MAX(JSON_ARRAY_LENGTH(tags)) as max_tags,
4
  MIN(JSON_ARRAY_LENGTH(tags)) as min_tags
5
FROM articles;