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 votes238 views1 answer
Update sql user password
SQL
0 vote285 views1 answer
How to move a columns location in mysql
SQL
0 vote236 views2 answers
Sql query unique
SQL
0 vote277 views1 answer
SQL joins in python
SQL
1 vote256 views2 answers
How to enable error squiggles in vs code
SQL
0 vote248 views1 answer
Restore backupfile discourse
SQL
2 votes239 views1 answer
Oracle create directory
SQL
1 vote250 views3 answers
Epoch to datetime
SQL
0 vote255 views1 answer
Mysql filter based on datediff
SQL
0 vote284 views1 answer
Mysql where sum > 0
SQL