MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


5.7.42


-- the JSON type and generated columns both arrived in MySQL 5.7
create table doc (
  id int,
  body json,
  name varchar(20) as (json_unquote(json_extract(body,'$.name'))) stored
);
insert into doc (id, body) values
  (1,'{"name":"ann","tags":["sql"]}'),
  (2,'{"name":"bob","tags":["graph"]}');

Records: 2  Duplicates: 0  Warnings: 0


select id, name, json_extract(body,'$.tags') as tags
from doc
order by id;


id
name
tags


1
ann
["sql"]

2
bob
["graph"]