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 votes220 views1 answer
Oracle create table comment
SQL
1 vote208 views1 answer
Psql import backup file for windows
SQL
7 votes195 views2 answers
Mysql get year from date
SQL
4 votes251 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote207 views1 answer
Where name ends in SQL
SQL
0 vote204 views1 answer
Oracle create job if not exists
SQL
1 vote295 views1 answer
Insert column after column mysql
SQL
0 vote211 views1 answer
Php select data from mysql database without column name
SQL
0 vote312 views1 answer
Insensitive case match sqlalchemy
SQL
6 votes196 views1 answer
Postgresql add enum value
SQL