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 vote231 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote233 views2 answers
Sql update top 100
SQL
3 votes240 views2 answers
Sql asc
SQL
1 vote221 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
0 vote245 views1 answer
Ver usuarios mysql
SQL
0 vote253 views4 answers
What is unique key in sql
SQL
0 vote241 views1 answer
Addition of 2 column value in mysql
SQL
2 votes245 views1 answer
Ssh mysql port forwarding
SQL
0 vote227 views1 answer
Mysql concat and use as where column
SQL
0 vote242 views1 answer
Sqlalchemy case insensitive like
SQL