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 vote278 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote285 views2 answers
Mysql add days to date
SQL
4 votes317 views5 answers
Get last query in codeigniter 4
SQL
6 votes282 views1 answer
Oracle rank() over (partition)
SQL
2 votes294 views1 answer
Sql create database
SQL
0 vote288 views1 answer
TSQL function split string
SQL
0 vote295 views1 answer
Mysql count number of occurrences in a column
SQL
50 votes357 views4 answers
Sql alter type of column
SQL
4 votes293 views2 answers
Postgresql default value
SQL
1 vote289 views1 answer
Apex select list ORA-20999
SQL