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 vote173 views1 answer
Oracle list chain steps
SQL
0 vote194 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote182 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
0 vote179 views1 answer
Stored procedures example
SQL
23 votes247 views2 answers
Query to delete a database in mysql
SQL
0 vote182 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote236 views1 answer
Mysql select row with min date
SQL
0 vote186 views2 answers
Mysql decimal remove trailing zeros
SQL
0 vote183 views7 answers
Les jointures sql server
SQL
0 vote183 views4 answers
Postgresql between month
SQL