Functions That Return JSON Value Attributes Returns a  utf8mb4  string indicating the type of a JSON value. This can be an object, an array, or a scalar type, as shown here: JSON_TYPE()  returns  NULL  if the argument is  NULL : 2374 mysql>  SELECT JSON_TYPE(NULL); +-----------------+ | JSON_TYPE(NULL) | +-----------------+ | NULL | mysql>  SET @j = ’{"a": [10, true]}’; mysql>  SELECT JSON_TYPE(@j); +---------------+ | JSON_TYPE(@j) | +---------------+ | OBJECT | +---------------+ mysql>  SELECT JSON_TYPE(JSON_EXTRACT(@j, ’$.a’)); +------------------------------------+ | JSON_TYPE(JSON_EXTRACT(@j, ’$.a’)) | +------------------------------------+ | ARRAY | +------------------------------------+ mysql>  SELECT JSON_TYPE(JSON_EXTRACT(@j, ’$.a[0]’)); +---------------------------------------+ | JSON_TYPE(JSON_EXTRACT(@j, ’$.a[0]’)) | +---------------------------------------+ | INTEGER | +---------------------------------------+ mysql>  SELECT JSON_TYPE(JSON_EXTRACT(@j, ’$.a[1]’)); +---------------------------------------+ | JSON_TYPE(JSON_EXTRACT(@j, ’$.a[1]’)) | +---------------------------------------+ | BOOLEAN | +---------------------------------------+ mysql>  SELECT JSON_LENGTH(’[1, 2, {"a": 3}]’); +---------------------------------+ | JSON_LENGTH(’[1, 2, {"a": 3}]’) | +---------------------------------+ | 3 | +---------------------------------+ mysql>  SELECT JSON_LENGTH(’{"a": 1, "b": {"c": 30}}’); +-----------------------------------------+ | JSON_LENGTH(’{"a": 1, "b": {"c": 30}}’) | +-----------------------------------------+ | 2 | +-----------------------------------------+ mysql>  SELECT JSON_LENGTH(’{"a": 1, "b": {"c": 30}}’, ’$.b’); +------------------------------------------------+ | JSON_LENGTH(’{"a": 1, "b": {"c": 30}}’, ’$.b’) | +------------------------------------------------+ | 1 | +------------------------------------------------+ •The length of an object is the number of object members. •The length does not count the length of nested arrays or objects. • JSON_TYPE( json_val )