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 (as a string), 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 | Example |
|---|---|---|
| ARRAY | JSON array | [1, 2, {"key": "value"}] |
| OBJECT | JSON object | {"key":"value"} |
| BOOLEAN | JSON true/false literals | true, false |
| DOUBLE | A number with at least one floating point decimal. | 1.2 |
| INTEGER | A number without a floating point decimal. | 1 |
| NULL | JSON null literal (this is returned as a string, not to be confused with the SQL NULL value!) | null |
| STRING | JSON String | "a sample string" |
Examples
SELECT JSON_TYPE('{"A": 1, "B": 2, "C": 3}');
+---------------------------------------+
| JSON_TYPE('{"A": 1, "B": 2, "C": 3}') |
+---------------------------------------+
| OBJECT |
+---------------------------------------+
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.
© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/json_type/