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 vote134 views1 answer
Get table which have specific columns in mysql
SQL
0 vote132 views1 answer
Snap craft
SQL
24 votes124 views2 answers
Alter table delete column
SQL
0 vote150 views1 answer
Mariadb change column type
SQL
4 votes237 views6 answers
Laravel jwt
SQL
1 vote128 views1 answer
Alter table column size oracle
SQL
3 votes152 views2 answers
Sqlite show table definition
SQL
2 votes139 views1 answer
Sql find not in list
SQL
0 vote135 views4 answers
How to get max salary in each department in sql
SQL
6 votes140 views2 answers
Foreign key sqlite3 python
SQL