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 vote206 views1 answer
Scheduled mysql database backup in linux
SQL
1 vote144 views1 answer
Funzioni plsql
SQL
16 votes194 views6 answers
Mysql find duplicates in same table
SQL
0 vote146 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
2 votes149 views3 answers
Current month mysql query
SQL
23 votes169 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote168 views1 answer
Leftjoin in sql
SQL
10 votes144 views1 answer
Oracle view dependencies
SQL
3 votes243 views1 answer
Postgresql today - 1 year
SQL
2 votes226 views1 answer
Oracle run_duration to number
SQL