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

16 votes106 views4 answers
Ascending order mysql
SQL
2 votes112 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote117 views1 answer
Mysql error 1251
SQL
0 vote118 views1 answer
Copy row from db to db mysql
SQL
5 votes92 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
3 votes103 views1 answer
RENAME table pl sql
SQL
0 vote145 views1 answer
Stop and start mysql
SQL
5 votes107 views1 answer
Sort order on two columns sql
SQL
1 vote99 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
1 vote105 views1 answer
Altering the column name in MySQL to have a default value
SQL