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

1 vote110 views1 answer
Table valued functions in sql
SQL
1 vote112 views2 answers
Postgresql check privileges on schema
SQL
0 vote100 views1 answer
Inserting data into different tables at once in oracle sql
SQL
6 votes100 views2 answers
Mysql get yesterday
SQL
0 vote93 views1 answer
Sql insert tuple
SQL
49 votes174 views6 answers
Get duplicate records in sql
SQL
0 vote119 views3 answers
Mysqli count down
SQL
0 vote102 views1 answer
Mysql config slave
SQL
1 vote109 views3 answers
Mysql disable foreign keys check
SQL
10 votes109 views1 answer
Oracle dependencies table
SQL