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 vote334 views1 answer
Count in sql and diff
SQL
0 vote354 views1 answer
Learnxinyminutes sql
SQL
0 vote346 views1 answer
Mssql unique key accept nulls
SQL
2 votes321 views2 answers
Postgres select duplicate columns
SQL
0 vote296 views1 answer
How to see the query of a view in mysql
SQL
0 vote285 views3 answers
Mysql calculate age from date of birth
SQL
0 vote332 views1 answer
Systems sql
SQL
0 vote315 views2 answers
Create new table plsql
SQL
0 vote336 views2 answers
Enter into postgresql database,create user and grant Access
SQL
1 vote332 views1 answer
Rows to comma separated values in mssql
SQL