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

9 votes393 views3 answers
Import DB through mysql console
SQL
0 vote340 views1 answer
Mysql regex exact match
SQL
0 vote346 views1 answer
Oracle string substitution
SQL
0 vote366 views1 answer
Mysql locate
SQL
0 vote357 views2 answers
Postgresql variable in query
SQL
0 vote392 views1 answer
Apt install sql server
SQL
1 vote374 views1 answer
Oracle sql first day of year
SQL
0 vote333 views1 answer
Remove default constraint sql server
SQL
9 votes373 views3 answers
Mysql run sql file
SQL
0 vote347 views2 answers
SQL Server Standard
SQL