Skip to main content
MariaDB

Keyboard users: Escape to exit.

Enterprise Documentation / Reference / Reference for MariaDB Enterprise Server / Functions / JSON_SEARCH()

Enterprise Documentation

Topics:

  • Deployment
  • Service Management
  • Connect and Query
  • Data Operations
  • Storage Engines
  • Security
  • SQL Reference
  • Architecture

Products:

  • MariaDB Enterprise
    • MariaDB ColumnStore
    • MariaDB Connectors
    • MariaDB MaxScale
    • MariaDB Server
    • MariaDB Xpand
  • MariaDB SkySQL DBaaS

Resources:

  • Reference Tables
  • Release Notes
  • What's New
  • Glossary
  • Sample Code
  • Feedback
  • MariaDB Forums
  • Support

Topics on This Page

  • Overview

  • EXAMPLES

  • CHANGE HISTORY

  • EXTERNAL REFERENCES

Reader Tools

  • Pages that link here
  • Pages linked from here
  • Send Feedback

JSON_SEARCH()

This page is part of MariaDB's Enterprise Documentation.

The parent of this page is: Functions

Topics on this page:

  • Overview

  • EXAMPLES

  • CHANGE HISTORY

  • EXTERNAL REFERENCES

Overview

A description for this Function has not yet been added to this Documentation.

See also: Functions in 10.6 ES, in 10.6 CS, in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS

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

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Added in MariaDB Community Server 10.2.3.

EXTERNAL REFERENCES

  • Additional information on this topic may be found in the MariaDB Public Knowledge Base.

  • Information specific to MariaDB SkySQL can be found on the JSON_SEARCH() page in the SkySQL Documentation.


© 2022 MariaDB. All rights reserved.

Products | Services | Resources

Legal | Privacy Policy | Cookie Policy

| | | Newsletter | About Us | Contact