n array. If two json documents are
scalars, it returns true if they have same type and value.

If none of the above conditions are satisfied then it returns false.

Examples
--------

SELECT JSON_OVERLAPS('false', 'false');
+---------------------------------+
| JSON_OVERLAPS('false', 'false') |
+---------------------------------+
| 1                               |
+---------------------------------+

SELECT JSON_OVERLAPS('true', '["abc", 1, 2, true, false]');
+----------------------------------------------------+
| JSON_OVERLAPS('true','["abc", 1, 2, true, false]') |
+----------------------------------------------------+
| 1                                                  |
+----------------------------------------------------+

SELECT JSON_OVERLAPS('{"A": 1, "B": {"C":2}}', '{"A": 2, "B": {"C":2}}') AS
is_overlap;
+---------------------+
| is_overlap          |
+---------------------+
| 1                   |
+---------------------+

Partial match is considered as no-match.

Examples
--------

SELECT JSON_OVERLAPS('[1, 2, true, false, null]', '[3, 4, [1]]') AS is_overlap;
+--------------------- +
| is_overlap           |
+----------------------+
| 0                    |
+----------------------+

URL: https://mariadb.com/kb/en/json_overlaps/https://mariadb.com/kb/en/json_overlaps/