JSON_LENGTH

Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

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.