Syntax:
JSON_OVERLAPS(json_doc1, json_doc2)

Compares two JSON documents. Returns true (1) if the two document have
any key-value pairs or array elements in common. If both arguments are
scalars, the function performs a simple equality test.

This function serves as counterpart to JSON_CONTAINS(), which requires
all elements of the array searched for to be present in the array
searched in. Thus, JSON_CONTAINS() performs an AND operation on search
keys, while JSON_OVERLAPS() performs an OR operation.

Queries on JSON columns of InnoDB tables using JSON_OVERLAPS() in the
WHERE clause can be optimized using multi-valued indexes.
https://dev.mysql.com/doc/refman/8.0/en/create-index.html#create-index-
multi-valued, provides detailed information and examples.

URL: https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html

