我如何做一个“NOT IN"?在 Mongo 中查询? [英] How do I do a "NOT IN" query in Mongo?

问题描述

这是我的文档:

{ 
    title:"Happy thanksgiving",
    body: "come over for dinner",
    blocked:[
       {user:333, name:'john'},
       {user:994, name:'jessica'},
       {user:11, name: 'matt'},
    ]
}

查找所有在blocked"中没有用户 11 的文档的查询是什么?

What is the query to find all documents that do not have user 11 in "blocked"?

推荐答案

您可以使用 $in 或 $nin 表示不在"

You can use $in or $nin for "not in"

示例...

> db.people.find({ crowd : { $nin: ["cool"] }});

我在这里放了更多例子:http://learnmongo.com/posts/成为人群中的一部分/

I put a bunch more examples here: http://learnmongo.com/posts/being-part-of-the-in-crowd/

这篇关于我如何做一个“NOT IN"?在 Mongo 中查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！