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 vote281 views1 answer
Oracle db get table sizes
SQL
0 vote267 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
4 votes277 views2 answers
Sql vs mysql
SQL
0 vote298 views1 answer
Postgresql auto increment not working
SQL
0 vote271 views2 answers
Change database postgres
SQL
0 vote278 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote304 views1 answer
Search from comma separated values in sql server
SQL
0 vote297 views2 answers
How to get the date from datetime in mysql
SQL
11 votes274 views1 answer
How to get ddl for materialized view
SQL
0 vote271 views1 answer
Order by monthly in sql
SQL