JSON_CONTAINS_PATH
Syntax
JSON_CONTAINS_PATH(json_doc, return_arg, path[, path] ...)
Description
Indicates whether the given JSON document contains data at the specified path or paths. Returns 1
if it does, 0
if not and NULL if any of the arguments are null.
The return_arg can be one
or all
:
one
- Returns1
if at least one path exists within the JSON document.all
- Returns1
only if all paths exist within the JSON document.
Examples
SET @json = '{"A": 1, "B": [2], "C": [3, 4]}'; SELECT JSON_CONTAINS_PATH(@json, 'one', '$.A', '$.D'); +------------------------------------------------+ | JSON_CONTAINS_PATH(@json, 'one', '$.A', '$.D') | +------------------------------------------------+ | 1 | +------------------------------------------------+ 1 row in set (0.00 sec) SELECT JSON_CONTAINS_PATH(@json, 'all', '$.A', '$.D'); +------------------------------------------------+ | JSON_CONTAINS_PATH(@json, 'all', '$.A', '$.D') | +------------------------------------------------+ | 0 | +------------------------------------------------+
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.