1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| create table json( id int not null auto_increment, json varchar(255) not null, primary key(id) );
insert into json(json) values('{"name": "Alice", "sex": "female", "age": 23}'); insert into json(json) values('{"name": "Bob", "sex": "male", "age": 20}');
select json_extract(json, '$.name') as name, json_extract(json, '$.sex') as sex, json_extract(json, '$.age') as age from json; + | name | sex | age | + | "Alice" | "female" | 23 | | "Bob" | "male" | 20 | + 2 rows in set (0.00 sec)
|