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

16 votes216 views3 answers
Get count of duplicate records
SQL
1 vote181 views1 answer
Oracle user last connected
SQL
2 votes197 views1 answer
Sql percentage with % rounded down
SQL
2 votes208 views5 answers
Install postgresql 10 centos 7
SQL
7 votes217 views2 answers
Phpmyadmin change password
SQL
0 vote201 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote214 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
11 votes193 views2 answers
Import sql file laravel cmd
SQL
1 vote188 views1 answer
User privileges postgresql information_schema
SQL
0 vote190 views1 answer
Sql server inner join convert collation
SQL