JSON_EQUALS

Syntax

JSON_EQUALS(json1, json2)

Description

Checks if there is equality between two json objects. Returns 1 if it there is, 0 if not, or NULL if any of the arguments are null.

Examples

SELECT JSON_EQUALS('{"a":[1, 2, 3]}', '{"a":[1, 2, 3]}');
+---------------------------------------------------+
| JSON_EQUALS('{"a":[1, 2, 3]}', '{"a":[1, 2, 3]}') |
+---------------------------------------------------+
|                                                 1 |
+---------------------------------------------------+

SELECT JSON_EQUALS('{"a":[1, 2, 3]}', '{"a":[1, 2, 3,4]}');
+-----------------------------------------------------+
| JSON_EQUALS('{"a":[1, 2, 3]}', '{"a":[1, 2, 3,4]}') |
+-----------------------------------------------------+
|                                                   0 |
+-----------------------------------------------------+

See Also

• JSON_NORMALIZE