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 vote213 views1 answer
Postgresql delete multiple rows
SQL
0 vote208 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote194 views1 answer
Mysql connection with sqlalchecmy
SQL
0 vote208 views1 answer
Restore backupfile discourse
SQL
150 votes358 views10 answers
Grepper
SQL
0 vote215 views1 answer
Default password for mysql_secure_installation in mac
SQL
0 vote229 views1 answer
Dockerfile example for Django
SQL
0 vote201 views1 answer
How to check if there is no database schema
SQL
0 vote219 views1 answer
Hashpass
SQL
0 vote206 views1 answer
Power bi union columns
SQL