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 vote150 views1 answer
Mysql query where in select
SQL
1 vote155 views1 answer
Mysql list bigger table
SQL
0 vote165 views1 answer
How to find table lock and row lock in mysql
SQL
20 votes190 views4 answers
How to find average in sql
SQL
0 vote141 views1 answer
Sql random decimal
SQL
11 votes236 views1 answer
Oracle insert from select
SQL
3 votes173 views1 answer
Unsigned int in mysql
SQL
11 votes154 views6 answers
Mysql else if
SQL
0 vote154 views1 answer
Pl sql search saurce code
SQL
5 votes141 views2 answers
Sql conn
SQL