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 vote348 views1 answer
Size of all tables in a schema oracle
SQL
0 vote348 views1 answer
Automated psql csv export script on windows
SQL
2 votes332 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
1 vote338 views1 answer
Sql drop with dependencies
SQL
18 votes330 views6 answers
Mysql create table
SQL
0 vote323 views1 answer
Heavy table in mysql
SQL
1 vote332 views2 answers
Check if word is in column sql
SQL
0 vote364 views1 answer
C# mysql data reader from two tables
SQL
1 vote346 views1 answer
Sql select all from one table and one column from another
SQL
0 vote334 views1 answer
Is not sql
SQL