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

5 votes346 views1 answer
Mysql last day of next month
SQL
0 vote318 views1 answer
Oracle sql winter time change
SQL
0 vote354 views1 answer
Mysql remove bad character from all fields
SQL
0 vote401 views1 answer
Reindexing all tables sql server
SQL
0 vote330 views1 answer
Sql comand for removing data from table
SQL
1 vote340 views1 answer
Declare table variable
SQL
0 vote320 views1 answer
Add timestamp column to existing table ms sql server
SQL
1 vote353 views1 answer
Customer using hdfc bank sql query
SQL
0 vote275 views1 answer
Postgresql add leading zeros
SQL
15 votes338 views1 answer
Mysql int range
SQL