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, 330🔥, 0💬
Popular Posts:
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...