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

0 vote351 views1 answer
Exec procedure oracle
SQL
0 vote346 views1 answer
Postgres call view
SQL
1 vote349 views1 answer
Mysql sort by date column
SQL
0 vote375 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
0 vote333 views1 answer
What is between operator
SQL
0 vote327 views1 answer
Format the money fied with comma in international system using sql
SQL
6 votes353 views4 answers
How to remove unique key in mysql
SQL
0 vote353 views1 answer
Trigger stock phpmyadmin output message
SQL
2 votes413 views1 answer
Pdo mysql insert
SQL
0 vote422 views1 answer
Mysql get nth highest
SQL