JSON_EXISTS()

Topics on this page:

Overview

Checks if the value at the specified path exists in the specified JSON document.

Returns 1 if the path is found and 0 if it is not.

JSON_EXISTS(<json_doc>, <path>)

SELECT JSON_EXISTS('{"a":"A", "b":"B", "c":[20, 30, 40]}', "$.c") AS result;

+--------+
| result |
+--------+
|      1 |
+--------+

SELECT JSON_EXISTS('{"a":"A", "b":"B", "c":[20, 30, 40]}', "$.d") AS result;

+--------+
| result |
+--------+
|      0 |
+--------+

Release Series	History
11.4 Enterprise	Not present.
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.

Release Series	History
11.4 Enterprise	Not present.
10.6 Enterprise	Present starting in MariaDB Enterprise Server 10.6.4-1.
10.5 Enterprise	Present starting in MariaDB Enterprise Server 10.5.3-1.
10.4 Enterprise	Present starting in MariaDB Enterprise Server 10.4.6-1.

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