Functions That Search JSON Values 1 row in set (0.00 sec) mysql>  SELECT JSON_OVERLAPS(’[[1,2],[3,4],5]’, ’[1,[2,3],[4,5]]’); +-----------------------------------------------------+ | JSON_OVERLAPS(’[[1,2],[3,4],5]’, ’[1,[2,3],[4,5]]’) | +-----------------------------------------------------+ | 0 | +-----------------------------------------------------+ 1 row in set (0.00 sec) mysql>  SELECT JSON_OVERLAPS(’{"a":1,"b":10,"d":10}’, ’{"c":1,"e":10,"f":1,"d":10}’); +-----------------------------------------------------------------------+ | JSON_OVERLAPS(’{"a":1,"b":10,"d":10}’, ’{"c":1,"e":10,"f":1,"d":10}’) | +-----------------------------------------------------------------------+ | 1 | +-----------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql>  SELECT JSON_OVERLAPS(’{"a":1,"b":10,"d":10}’, ’{"a":5,"e":10,"f":1,"d":20}’); +-----------------------------------------------------------------------+ | JSON_OVERLAPS(’{"a":1,"b":10,"d":10}’, ’{"a":5,"e":10,"f":1,"d":20}’) | +-----------------------------------------------------------------------+ | 0 | +-----------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql>  SELECT JSON_OVERLAPS(’5’, ’5’); +-------------------------+ | JSON_OVERLAPS(’5’, ’5’) | +-------------------------+ | 1 | +-------------------------+ 1 row in set (0.00 sec) mysql>  SELECT JSON_OVERLAPS(’5’, ’6’); +-------------------------+ | JSON_OVERLAPS(’5’, ’6’) | +-------------------------+ | 0 | +-------------------------+ 1 row in set (0.00 sec) mysql>  SELECT JSON_OVERLAPS(’[4,5,6,7]’, ’6’); +---------------------------------+ | JSON_OVERLAPS(’[4,5,6,7]’, ’6’) | +---------------------------------+ | 1 | +---------------------------------+ 1 row in set (0.00 sec) mysql>  SELECT JSON_OVERLAPS(’[4,5,"6",7]’, ’6’); +-----------------------------------+ | JSON_OVERLAPS(’[4,5,"6",7]’, ’6’) | The function does not perform type conversions: When comparing a scalar with an array,  JSON_OVERLAPS()  attempts to treat the scalar as an array element. In this example, the second argument  6  is interpreted as  [6] , as shown here: If two scalars are used as the arguments to the function,  JSON_OVERLAPS()  performs a simple test for equality: Partial matches are treated as no match, as shown here: When comparing objects, the result is true if they have at least one key-value pair in common. 2355