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 vote268 views1 answer
Ignore case in string sql
SQL
1 vote269 views1 answer
Apex select list ORA-20999
SQL
5 votes281 views1 answer
Commentaire table oracle
SQL
0 vote311 views1 answer
Error code 1451 sql
SQL
3 votes274 views4 answers
Stop MySQL
SQL
5 votes282 views4 answers
Change auto increment mysql
SQL
3 votes303 views5 answers
Sql select
SQL
6 votes287 views3 answers
Oracle all dates between two dates
SQL
25 votes287 views4 answers
Sqlserver add column
SQL
0 vote268 views2 answers
Return the number of records in a single table mysql
SQL