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 vote141 views1 answer
Import mysql'
SQL
-1 vote142 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote195 views1 answer
Do you know sql
SQL
-1 vote143 views1 answer
Partial search in sql
SQL
0 vote164 views1 answer
How much space does sql server take per row
SQL
3 votes141 views2 answers
Mysql update row
SQL
3 votes143 views4 answers
Truncate syntax in sql
SQL
-1 vote145 views1 answer
How to dump .csv file into mysql
SQL
0 vote137 views1 answer
Tsql default value when no value returned by query
SQL
0 vote157 views2 answers
Mysql insert into multiple tables
SQL