JSON_SEARCH()
This page is part of MariaDB's MariaDB 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_SEARCH(@json, 'one', 2);
+------------------------------+
| JSON_SEARCH(@json, 'one', 2) |
+------------------------------+
| "$.2" |
+------------------------------+
SELECT JSON_SEARCH('{"a": 1, "b": 1, "c": 3}', 'all', 1);
+---------------------------------------------------+
| JSON_SEARCH('{"a": 1, "b": 1, "c": 3}', 'all', 1) |
+---------------------------------------------------+
| ["$.a", "$.b"] |
+---------------------------------------------------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.