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 vote229 views2 answers
Mysql to python pandas
SQL
0 vote239 views4 answers
First max salary in sql
SQL
0 vote283 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote258 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote259 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote217 views1 answer
Cannot start database server xampp mac os
SQL
0 vote226 views2 answers
Mysql on update current_timestamp
SQL
1 vote240 views1 answer
Mysql drop key
SQL
0 vote223 views1 answer
Postgressql uuid
SQL
0 vote220 views1 answer
Events not working db
SQL