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 vote167 views1 answer
Mysql date minus 1 day
SQL
3 votes161 views1 answer
How to remove characters from string in mysql
SQL
14 votes195 views3 answers
Oracle sql limit results
SQL
0 vote184 views1 answer
Prodection ready postgres database step by step
SQL
0 vote167 views1 answer
How to define a save method in ruby for sql databases
SQL
0 vote182 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
0 vote158 views1 answer
Ffeathers express mysql application users login
SQL
1 vote176 views5 answers
What is in operator in sql
SQL
0 vote178 views1 answer
Postrgres trunc
SQL
1 vote183 views1 answer
Oracle turn off constraint
SQL