Skip to main content

SingleStoreDB v8.0

JSON_GET_TYPE

Returns the Javascript type of the given JSON object.

JSON_GET_TYPE(json)

Arguments

  • json: a valid JSON value.

Return Value

The type is returned as one of the following strings:

  • “boolean”

  • “double”

  • “string”

  • “array”

  • “object”

  • “null”

  • Or, SQL NULL if json is not a valid JSON object.

Examples

SELECT JSON_GET_TYPE('true');

****
+-----------------------+
| json_get_type('true') |
+-----------------------+
| boolean               |
+-----------------------+

SELECT JSON_GET_TYPE('12345');

****
+------------------------+
| JSON_GET_TYPE('12345') |
+------------------------+
| double                 |
+------------------------+
SELECT JSON_GET_TYPE('"alpha, beta, gamma"');

****
+---------------------------------------+
| JSON_GET_TYPE('"alpha, beta, gamma"') |
+---------------------------------------+
| string                                |
+---------------------------------------+
SELECT JSON_GET_TYPE('[1,2,3]');

****
+--------------------------+
| JSON_GET_TYPE('[1,2,3]') |
+--------------------------+
| array                    |
+--------------------------+
SELECT JSON_GET_TYPE('{"alpha”:1, "beta”:2}’);

****
+----------------------------------------+
| JSON_GET_TYPE('{"alpha":1, "beta":2}') |
+----------------------------------------+
| object                                 |
+----------------------------------------+
SELECT JSON_GET_TYPE('null');

****
+-----------------------+
| JSON_GET_TYPE('null') |
+-----------------------+
| null                  |
+-----------------------+

Note

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

In this section: