JSON_EQUALS()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
In 23.08 ES, 23.07 ES, 10.6 ES, 10.5 ES, 10.4 ES:
A description for this Function has not yet been added to this Documentation.
EXAMPLES
SET @json1 = '[
"a" ,
{ "b" : [ 1 , 2 ] } ,
[ 3 , 4 ]
] ';
SET @json2 = '[ "a", {"b":[1,2]}, [ 3,4 ] ]';
SELECT JSON_EQUALS(@json1, @json2) AS result;
+--------+
| result |
+--------+
| 1 |
+--------+
SET @json1 = '{"b": 2, "a": 1}';
SET @json2 = '{"a": 1, "b": 2}';
SELECT JSON_EQUALS(@json1, @json2) AS result;
+--------+
| result |
+--------+
| 1 |
+--------+