Collections:
JSON_OVERLAPS() - Checking JSON Overlaps
How to check if two JSON values have overlaps using the JSON_OVERLAPS() function?
✍: FYIcenter.com
JSON_OVERLAPS(json1, json2) is a MySQL built-in function that detects overlaps of two JSON values using the following rules:
For example:
SELECT JSON_OVERLAPS("[1,3,5,7]", "[2,5,7]"); -- +---------------------------------------+ -- | JSON_OVERLAPS("[1,3,5,7]", "[2,5,7]") | -- +---------------------------------------+ -- | 1 | -- +---------------------------------------+ 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 | -- +-----------------------------------------------------------------------+ SELECT JSON_OVERLAPS('5', '5'); -- +-------------------------+ -- | JSON_OVERLAPS('5', '5') | -- +-------------------------+ -- | 1 | -- +-------------------------+ SELECT JSON_OVERLAPS('[4,5,6,7]', '6'); -- +---------------------------------+ -- | JSON_OVERLAPS('[4,5,6,7]', '6') | -- +---------------------------------+ -- | 1 | -- +---------------------------------+ SELECT JSON_OVERLAPS('{"a": 6}', '6'); -- +--------------------------------+ -- | JSON_OVERLAPS('{"a": 6}', '6') | -- +--------------------------------+ -- | 0 | -- +--------------------------------+ SELECT JSON_OVERLAPS('{"a": 6}', '["a",6]'); -- +--------------------------------------+ -- | JSON_OVERLAPS('{"a": 6}', '["a",6]') | -- +--------------------------------------+ -- | 0 | -- +--------------------------------------+
Reference information of the JSON_OVERLAPS() function:
JSON_OVERLAPS(json1, json2): int Returns 1 if two JSON values has an overlap. Otherwise it returns 0. Arguments, return value and availability: json1, json2: Required. The JSON values to be compared. int: Return value. The comparison result, 0 or 1. Available since MySQL 8.0.
⇒ JSON_PRETTY() - Validating JSON Value
⇐ JSON_OBJECT() - Creating JSON Object
2023-12-15, 243🔥, 0💬
Popular Posts:
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...