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 vote215 views1 answer
Sqlcl format
SQL
0 vote178 views1 answer
Postgresql get current user name
SQL
10 votes191 views3 answers
Join multiple tables sql
SQL
0 vote144 views1 answer
Flask_sqlalchemy install
SQL
1 vote185 views1 answer
Mysql show table character set
SQL
2 votes327 views1 answer
How to create sql database
SQL
18 votes210 views2 answers
Sql comments
SQL
0 vote211 views1 answer
Get total and distict row diff in sql
SQL
0 vote197 views1 answer
Como hacer una consulta en sql
SQL
1 vote185 views1 answer
Postgresql substring last
SQL