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 vote178 views1 answer
Executescalar in sql server
SQL
0 vote213 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
2 votes238 views1 answer
Oracle run_duration to number
SQL
0 vote160 views1 answer
Linebreak sql
SQL
6 votes159 views2 answers
Oracle undotbs usage
SQL
2 votes107 views1 answer
Select sid oracle
SQL
6 votes147 views4 answers
Delete table sqlite
SQL
0 vote180 views1 answer
Sqlite version check
SQL
1 vote160 views1 answer
Adding a default constraint to an existing column in sql
SQL
1 vote151 views1 answer
Mysql check string don't have number
SQL