Query for MongoDB

Question

How to remove a document in MongoDB where I want to remove id 1 to 1000, In the collection, I have 10 million documents.

db.posts.remove(
 { "id": 1 to 1000}
 )

Possible duplicate of [How to delete N numbers of documents in mongodb](https://stackoverflow.com/questions/19065615/how-to-delete-n-numbers-of-documents-in-mongodb) — Ashh, Sep 29 '18 at 09:36

score 2 · Accepted Answer · answered Sep 29 '18 at 09:43

2

db.posts.remove({"id": { "$gte": 1, "$lte":1000 }});

answered Sep 29 '18 at 09:43

Lemix

score 0 · Answer 2 · edited Oct 04 '18 at 01:42

0

You can execute the command below on shell

db.posts.deleteMany({$and: [{"id": { $gte: 1} }, {"id": { $lte: 1000} }] )

For reference, you can also visit MongoDocs.

edited Oct 04 '18 at 01:42

Pang

answered Sep 29 '18 at 09:36

score 0 · Answer 3 · answered Sep 29 '18 at 09:39

0

You can use this query

db.posts.remove({"$and" : [{"id" :{"$gte" :1}},{"id" :{"$lte" :1000}}]})

answered Sep 29 '18 at 09:39

Senthur Deva

3 Answers3