json_extract is a function for extract data from a JSON document both in MySQL and MariaDB. The function normally works fine, for example 1set @j = '{"num": 42, "list": [1, 2, 3], "obj": {"name": "Edward Stark"}}'; 2select json_extract(@j, '$.num') as num, json_extract(@j, '$.list') as list, json_extract(@j, '$.obj') …

Read More