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

2 votes120 views1 answer
Q operator in plsql
SQL
0 vote118 views2 answers
Oracle select
SQL
5 votes111 views1 answer
Oracle asynchronous query
SQL
2 votes113 views2 answers
Spring import sql
SQL
1 vote133 views1 answer
Key validation sql
SQL
3 votes126 views1 answer
Postgres kill running query
SQL
6 votes110 views1 answer
Update left join mysql
SQL
1 vote124 views1 answer
Load mysql dumb
SQL
8 votes116 views3 answers
Postgres database sizes
SQL
0 vote71 views1 answer
How to check oracle index table
SQL