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

3 votes165 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
5 votes250 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
7 votes170 views1 answer
Minecraft forge server host
SQL
1 vote174 views1 answer
Oracle rolling back transactions
SQL
0 vote178 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote182 views1 answer
Ajouter une clé etrangere mysql
SQL
0 vote198 views1 answer
Mysql value ends with
SQL
2 votes227 views2 answers
Postgres drop column if exists
SQL
4 votes178 views3 answers
Sql drop primary key
SQL
0 vote259 views1 answer
Do you know sql
SQL