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 vote197 views1 answer
MySql get primary keys of table
SQL
0 vote236 views1 answer
Postgres dump sql insert
SQL
1 vote190 views1 answer
Age postgres
SQL
0 vote167 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
3 votes190 views1 answer
Mysql insert on dupèlicate
SQL
0 vote178 views1 answer
Find all tables where column name exists oracle
SQL
1 vote184 views2 answers
Oracle replace
SQL
1 vote252 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
2 votes169 views1 answer
Update with join sql server
SQL
0 vote162 views1 answer
Sql get month and year from date
SQL