JSON functions were added in MariaDB 10.2.3.
JSON_VALUE(json_doc, path)
Given a JSON document, returns the scalar specified by the path. Returns NULL if not given a valid JSON document, or if there is no match.
select json_value('{"key1":123}', '$.key1'); +--------------------------------------+ | json_value('{"key1":123}', '$.key1') | +--------------------------------------+ | 123 | +--------------------------------------+ select json_value('{"key1": [1,2,3], "key1":123}', '$.key1'); +-------------------------------------------------------+ | json_value('{"key1": [1,2,3], "key1":123}', '$.key1') | +-------------------------------------------------------+ | 123 | +-------------------------------------------------------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/json_value/