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 votes239 views1 answer
Sql online test questions and answers
SQL
2 votes208 views2 answers
Sql percentage
SQL
15 votes204 views4 answers
Create table if not exists sql
SQL
6 votes249 views2 answers
Oracle compile trigger
SQL
6 votes212 views1 answer
SQL insert all columns
SQL
0 vote243 views1 answer
Retornar apenas o ano mysql date
SQL
1 vote337 views1 answer
Mysql monthname
SQL
0 vote202 views1 answer
Set default value now() date
SQL
4 votes212 views4 answers
Pl sql output
SQL
0 vote195 views1 answer
Sqlite select split string
SQL