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 vote197 views1 answer
Truncate table in postgresql and reset id
SQL
0 vote118 views2 answers
Sqlite
SQL
0 vote128 views1 answer
Error code 1451 sql
SQL
1 vote116 views1 answer
Using SQL in rails migration
SQL
0 vote126 views1 answer
Kill a pid redshift
SQL
0 vote132 views1 answer
Mysql c commands
SQL
0 vote123 views1 answer
Order by with where clause in mysql
SQL
79 votes295 views6 answers
Grepper code
SQL
1 vote122 views1 answer
Postgresql substring last
SQL
0 vote138 views2 answers
Drop tables from local table database postgres
SQL