Collections:
JSON_CONTAINS_PATH() - Finding Path in JSON
How to verify if a JSON path exists in a JSON (JavaScript Object Notation) value using the JSON_CONTAINS_PATH() function?
✍: FYIcenter.com
JSON_CONTAINS_PATH(json, one_or_all, path1, path2, ...) is a MySQL built-in function that verifies if one or all specified paths exist in a given JSON value. For example:
SET @j = '{"a": 1, "b": 2, "c": {"d": 4}}'; SELECT JSON_CONTAINS_PATH(@j, 'one', '$.a', '$.e'); -- +---------------------------------------------+ -- | JSON_CONTAINS_PATH(@j, 'one', '$.a', '$.e') | -- +---------------------------------------------+ -- | 1 | -- +---------------------------------------------+ SELECT JSON_CONTAINS_PATH(@j, 'all', '$.a', '$.e'); -- +---------------------------------------------+ -- | JSON_CONTAINS_PATH(@j, 'all', '$.a', '$.e') | -- +---------------------------------------------+ -- | 0 | -- +---------------------------------------------+ SELECT JSON_CONTAINS_PATH(@j, 'one', '$.c.d'); -- +----------------------------------------+ -- | JSON_CONTAINS_PATH(@j, 'one', '$.c.d') | -- +----------------------------------------+ -- | 1 | -- +----------------------------------------+ SELECT JSON_CONTAINS_PATH(@j, 'one', '$.a.d'); -- +----------------------------------------+ -- | JSON_CONTAINS_PATH(@j, 'one', '$.a.d') | -- +----------------------------------------+ -- | 0 | -- +----------------------------------------+
Reference information of the JSON_CONTAINS_PATH() function:
JSON_CONTAINS_PATH(json, one_or_all, path1, path2, ...): int Verifies if one or all specified paths exist in a given JSON value. Arguments, return value and availability: json: Required. The JSON value to be searched in. one_or_all: Required. The search option: "one" or "all". path1, path2, ...: One or more JSON paths to search for. int: Return value. The verification result. Available since MySQL 5.7.
⇒ JSON_DEPTH() - Calculating Depth of JSON Value
⇐ JSON_CONTAINS() - Finding JSON in JSON
2023-12-11, 237🔥, 0💬
Popular Posts:
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...