JSON_TYPE

MariaDB starting with 10.2.3

JSON functions were added in MariaDB 10.2.3.

Syntax

JSON_TYPE(json_val)

Description

Returns the type of a JSON value, or NULL if the argument is null.

An error will occur if the argument is an invalid JSON value.

The following is a complete list of the possible return types:

Return type	Value
ARRAY	JSON array
BIT	MariaDB BIT scalar
BLOB	MariaDB binary types (BINARY, VARBINARY or BLOB)
BOOLEAN	JSON true/false literals
DATE	MariaDB DATE scalar
DATETIME	MariaDB DATETIME or TIMESTAMP scalar
DECIMAL	MariaDB DECIMAL or NUMERIC scalar
DOUBLE	MariaDB DOUBLE FLOAT scalar
INTEGER	MariaDB integer types (TINYINT, SMALLINT, MEDIUMINT, INT or BIGINT)
NULL	JSON null literal or NULL argument
OBJECT	JSON object
OPAQUE	Any valid JSON value that is not one of the other types.
STRING	MariaDB character types (CHAR, VARCHAR, TEXT, ENUM or SET)
TIME	MariaDB TIME scalar

Examples

SELECT JSON_TYPE('{"A": 1, "B": 2, "C": 3}');
+---------------------------------------+
| JSON_TYPE('{"A": 1, "B": 2, "C": 3}') |
+---------------------------------------+
| OBJECT                                |
+---------------------------------------+

Comments

Comments loading...

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.