How to get json data mysql

SELECT 
    id, client_id, service_id,
    json_extract(service_values, '$.quota') AS quota,
    json_extract(service_values, '$.free_quota') AS free_quota,
    json_extract(service_values, '$.total_accounts') AS total_accounts,
    json_extract(service_values, '$.data_transfer') AS data_transfer
FROM client_services;

Source: stackoverflow.com

How to get json data mysql

SELECT 
    ID, CITY,
    json_extract(POPULATION_JSON_DATA, '$.male') AS POPL_MALE,
    json_extract(POPULATION_JSON_DATA, '$.female') AS POPL_FEMALE,
    json_extract(POPULATION_JSON_DATA, '$.other') AS POPL_OTHER
FROM TBL_JSON;

Source: stackoverflow.com

Similar codes

3 votes303 views2 answers
Truncate all tables
SQL
5 votes324 views2 answers
Oracle find all tables with column name
SQL
0 vote322 views1 answer
Proc sql not in working
SQL
0 vote313 views1 answer
Postgresql get diff between two dates in Months
SQL
10 votes312 views4 answers
How to alter table name in mysql
SQL
1 vote318 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
-1 vote298 views3 answers
Mysql get age from date
SQL
0 vote330 views1 answer
How do I insert a blob in SQL?
SQL
0 vote388 views1 answer
How to subquey to do not load in live database in
SQL
0 vote310 views2 answers
Select columns from 2 tables with foreign key
SQL