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

5 votes116 views1 answer
Minecraft java port number
SQL
0 vote115 views1 answer
Optimize sql query
SQL
3 votes238 views6 answers
Sql unique select
SQL
8 votes82 views1 answer
Similarities between ddl and dml
SQL
1 vote126 views1 answer
Postgres count string length
SQL
0 vote124 views1 answer
Drop view in mysql
SQL
0 vote185 views1 answer
Sql to search who modified
SQL
12 votes132 views5 answers
Sql primary key
SQL
0 vote121 views1 answer
Oracle shrink table
SQL
0 vote126 views1 answer
SQL Error 1040 : Too many connections
SQL