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, 218🔥, 0💬
Popular Posts:
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...