JSON functions were added in MariaDB 10.2.3.
JSON_CONTAINS_PATH(json_doc, return_arg, path[, path] ...)
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
- Returns 1
if at least one path exists within the JSON document. all
- Returns 1
only if all paths exist within the JSON document. 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 | +------------------------------------------------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/json_contains_path/