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 vote172 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote126 views1 answer
Change database name psql 8
SQL
0 vote140 views1 answer
GROUP BY postgres
SQL
0 vote170 views1 answer
Postgresql concat string with separator
SQL
1 vote163 views1 answer
Mysql return text after a final full stop
SQL
1 vote194 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote129 views1 answer
Psql datestyle
SQL
1 vote147 views1 answer
Select tables with name like mysql
SQL
7 votes136 views2 answers
What is sql clause
SQL
6 votes127 views2 answers
How to copy data in sql
SQL