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 vote311 views2 answers
Sql select only first occurrence
SQL
3 votes305 views2 answers
WhereIn SQL
SQL
3 votes324 views1 answer
Oracle drop user
SQL
12 votes344 views4 answers
How to check mysql version ubuntu
SQL
0 vote343 views1 answer
Mysql faster delete
SQL
0 vote333 views1 answer
Apex for oracle 11g
SQL
0 vote321 views1 answer
Convert polygon to text in mysql
SQL
0 vote313 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
1 vote359 views1 answer
Find size of all DB's postgres
SQL
0 vote330 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL