Mongo db not equal to query not working

Question

I am trying to select all different from "overview" in a mongodb collection. I use the query below but it does not work...

hist = db.find({'type':{$ne:'overview'}})

If I try without the $ne it works...

Any ideas on what is wrong?

Thanks!

Update

Just fixed... had to quote the "$ne"

Missing colon? :. I've never used mongodb, but googling the syntax for $neshowed me examples with that syntax. — keyser
– keyser, Commented Apr 27, 2014 at 17:38
And that why you should always copy-paste. Make it reproducable. Also, your new edit has the colon within the string, that's still wrong. — keyser
– keyser, Commented Apr 27, 2014 at 17:43

keyser · Accepted Answer · 2014-04-27 17:53:13Z

0

You need to put quotation marks around $ne since pymongo uses dicts as parameters. It can't interpret { $ne : 'overview' } since $ne isn't a variable. Long story short, try this:

hist = db.find({'type':{'$ne':'overview'}})

answered Apr 27, 2014 at 17:53

keyser

19.3k16 gold badges62 silver badges103 bronze badges

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

Comments

Eric Smallwood · Accepted Answer · 2014-04-27 17:44:53Z

0

You're colon for $ne is inside the quotes, change to:

hist = db.find({'type':{$ne:'overview'}})

answered Apr 27, 2014 at 17:44

Eric Smallwood

11 bronze badge

2 Comments

user2950162 Over a year ago

its like this and I keep getting syntax error everytime I put $ne or $all in a query...

Eric Smallwood Over a year ago

Ahh, ok. One more thing though, i don't believe you need quotations around type, since you are not searching on a sub-document of type. try removing the single quotes.

Collectives™ on Stack Overflow

Mongo db not equal to query not working

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related