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 vote119 views1 answer
How to get alternate records from a table in sql
SQL
2 votes99 views1 answer
How to delete columns in sql
SQL
2 votes145 views1 answer
How to select from mssql
SQL
0 vote108 views2 answers
Mysql to python pandas
SQL
0 vote135 views1 answer
Sp help text in postgresql
SQL
0 vote135 views1 answer
Hour differeence in mysql
SQL
0 vote115 views2 answers
Transaction php
SQL
16 votes101 views4 answers
Sort by sql
SQL
0 vote104 views2 answers
Select columns from 2 tables with foreign key
SQL
0 vote111 views1 answer
Java mysql swing example
SQL