JSON_CONTAINS_PATH()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
A description for this Function has not yet been added to this Documentation.
EXAMPLES
SET @json = '{"1": 1, "2": 2, "c": 3}';
SELECT JSON_CONTAINS_PATH(@json, 'one', '$.1', '$.a');
+------------------------------------------------+
| JSON_CONTAINS_PATH(@json, 'one', '$.1', '$.a') |
+------------------------------------------------+
| 1 |
+------------------------------------------------+
SET @json = '{"1": 1, "2": 2, "c": 3}';
SELECT JSON_CONTAINS_PATH(@json, 'all', '$.1', '$.c');
+------------------------------------------------+
| JSON_CONTAINS_PATH(@json, 'all', '$.1', '$.c') |
+------------------------------------------------+
| 1 |
+------------------------------------------------+
SET @json = '{"1": 1, "2": 2, "c": 3}';
SELECT JSON_CONTAINS_PATH(@json, 'one', '$.3', '$.a');
+------------------------------------------------+
| JSON_CONTAINS_PATH(@json, 'one', '$.3', '$.a') |
+------------------------------------------------+
| 0 |
+------------------------------------------------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.