JSON_EXTRACT
You are viewing an old version of this article. View
the current version here.
MariaDB starting with 10.2.3
JSON functions were added in MariaDB 10.2.3.
Syntax
JSON_EXTRACT(json_doc, path[, path] ...)
Description
Extracts data from a JSON document. The extracted data is selected from the parts matching the path arguments. Returns all matched values; either as a single matched value, or, if the arguments could return multiple values, a result autowrapped as an array in the matching order.
Returns NULL if no paths match or if any of the arguments are NULL.
An error will occur if any path argument is not a valid path, or if the json_doc argument is not a valid JSON document.
Note that in MariaDB 10.2.3, there is a bug causing JSON_EXTRACT to return incorrect results. See MDEV-11571.
Examples
SET @json = '[1, 2, [3, 4]]'; SELECT JSON_EXTRACT(@json, '$[1]'); +-----------------------------+ | JSON_EXTRACT(@json, '$[1]') | +-----------------------------+ | [2, [3, 4]] | +-----------------------------+
SELECT JSON_EXTRACT(@json, '$[2][1]'); +--------------------------------+ | JSON_EXTRACT(@json, '$[2][1]') | +--------------------------------+ | 4 | +--------------------------------+
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.