How to remove element from array in mongodb

Question

Hi I've got such kind of structure. here is an example

{
    "_id" : "423dswar23ew2355",
    "competitions" : [ 
        "24",
        "58", 
        "354",
        "361"
    ],
}

How I can delete for example "58" item from "competitions" array.

I've seen some kind of solution like

{ $pull: { competitions: { $eq: "58" }}}

But my mongo says thar

MongoError: unknown top level operator: $eq

So can anybody come up with some more simple but at the same time working solution. Thanks in advance

mickl · Accepted Answer · 2018-04-02 19:08:05Z

1

Try following code:

db.col.update({_id: "423dswar23ew2355"}, { $pull: { "competitions": "58" } })

Remember that since you have strings you should pass "58" as a string.

answered Apr 2, 2018 at 19:08

mickl

50.1k9 gold badges71 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Meshack Mbuvi · Accepted Answer · 2019-05-01 09:21:59Z

1

This should work for the new versions:

db.col.updateOne({_id: "423dswar23ew2355"}, { $pull: { "competitions": "58" } })

answered May 1, 2019 at 9:21

Meshack Mbuvi

4114 silver badges16 bronze badges

Ria Anggraini · Accepted Answer · 2018-04-03 04:50:01Z

0

if you want to delete the 58, you can use

db.lists.update({}, {$unset : {"competitions.2" : 1 }})

then

db.lists.update({}, {$pull : {"competitions" : null}})

hope it could help you

answered Apr 3, 2018 at 4:50

Ria Anggraini

2,7452 gold badges11 silver badges26 bronze badges