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 vote146 views1 answer
Psql list view rules
SQL
6 votes155 views3 answers
Create database mysql utf8
SQL
0 vote131 views1 answer
Export partttion and import in oracle
SQL
0 vote150 views1 answer
Sql column contains special character
SQL
1 vote160 views2 answers
Drop table if exists test
SQL
0 vote181 views1 answer
Sql query to select even numbers
SQL
2 votes194 views1 answer
Oracle block
SQL
1 vote158 views1 answer
Join to find results not in another table
SQL
0 vote170 views1 answer
Sql insert from excel
SQL
0 vote105 views0 answer
SQL