I've a column that contain json values like
我有一个包含json值的列,如下所示
[
{
"name": "enabled",
"value": "true",
"type": "boolean"
},
{
"name": "limit_amount_per_day",
"value": "100",
"type": "text",
"pattern": "^[0-9]*$",
"min": "0",
"max": "100000"
},
{
"name": "limit_amount_per_month",
"value": "1000",
"type": "text",
"pattern": "^[0-9]*$",
"min": "0",
"max": "100000"
},
]
or can be in
或者可以在
[{"name": "enabled", "value": "true", "type": "boolean"}, {"name": "limit_amount_per_day", "value": "100", "type": "text", "pattern": "^[0-9]*$", "min": "0", "max": "100000"}, {"name": "limit_amount_per_month", "value": "1000", "type": "text", "pattern": "^[0-9]*$", "min": "0", "max": "100000"},]
How can I query inside column in sql ?
如何在SQL中查询内部列?
For example... from that json , i want to get value that contains name 'enabled' so i could use it in another queries.
比如..。从该json中,我希望获得包含名称‘Enable’的值,以便可以在另一个查询中使用它。
What i've tried was
SELECT * FROM SOME_TABLE where value LIKE '%"name":"enabled", "value": "boolean"%'
but it is very error prone .
我尝试过的是SELECT*FROM SOME_TABLE WHERE VALUE LIKE‘%“NAME”:“ENABLED”,“VALUE”:“Boolean”%’,但它非常容易出错。
Anybody can find out way with this?
有谁能找到解决这个问题的办法?
更多回答
我是一名优秀的程序员,十分优秀!