Important

New database features are no longer connected to engine versions; features are now enabled independently during scheduled update windows, and “major” and “minor” releases no longer exist in Helios. Please visit the release notes to view the latest features available in your database clusters.

JSON_LENGTH

Arguments

json: a valid JSON array or map.

Return Value

the length as an integer.
SQL NULL if json is not a valid JSON array or map.

Examples

SQL

SELECT JSON_LENGTH('true');

+---------------------+
| JSON_LENGTH('true') |
+---------------------+
|                NULL |
+---------------------+

SQL

SELECT JSON_LENGTH('[1,2,3]');

+------------------------+
| JSON_LENGTH('[1,2,3]') |
+------------------------+
|                      3 |
+------------------------+

SQL

SELECT JSON_LENGTH('{"alpha": 1, "beta": 2}');

+----------------------------------------+
| JSON_LENGTH('{"alpha": 1, "beta": 2}') |
+----------------------------------------+
|                                      2 |
+----------------------------------------+

Note

A JSON or Javascript null value is distinct from SQL NULL.

JSON_LENGTH

On this page

Arguments

Return Value

Examples

Was this article helpful?

On this page

Was this article helpful?