Questions tagged [json-remove]
5 questions
2
votes
1 answer
How to delete keys in JSON column of MySQL
My data is dirty, and now I am trying to correct them.
The data is like:
mysql> select attrs from goods limit…
shijie xu
- 1,975
- 21
- 52
0
votes
1 answer
How to remove a string element from an array everywhere in a SQLite table?
Considering a SQLite table where one column (named domain) is an array of strings with no particular index/order.
Example: ["google", "apple", "twitter"]
How can I update the all table to delete all google items?
In my example, result should be…
charnould
- 2,480
- 3
- 19
- 23
0
votes
1 answer
json_search and json_remove in mysql
notice
[
{
"date": "2022. 10. 16.",
"type": 3,
"title": "friend",
"content": "JJ friend",
"parameter": "test"
},
{
"date": "2022. 10. 16.",
"type": 3,
"title": "friend",
"content": "testtest friend",
…
JiNyeok_S
- 3
- 2
0
votes
0 answers
How can I remove an element from a JSON array using MySQL?
I have a table with JSON data like this:
{"entries": [{"color": "blue", "value": 15, "name": "john"}, {"color": "red", "value": 30, "name": "doe"}]}
I need to remove the object in the array that has value x.
The code I have so far is:
SELECT…
shalomew
- 49
- 4
0
votes
0 answers
Remove JSON object from json array in mysql
I have a column that saves JSON string and I want to get rid of "zipcode" for that JSON object. How can I achieve that using MySQL functions?
{name:"Alex", "address": [
{"type": "primary", "street": "bakers street", "zipcode": 90001},
{"type":…
ps_403
- 23
- 4