blocks|key|1387520|text|你可以使用regex。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1387521|在您的示例中，这将是：|1387522|db.stuff.find(+{+foo:+/%5Ebar$/i+}+);|code-block|syntax|javascript|1387523|不过，我必须说，也许你可以在导入的过程中将值小写(或大写)，而不是每次找到它时都会招致额外的成本。显然，这不适用于人名之类的，但可能是像标签这样的用例。|1387524|entityMap|0|LINK|mutability|MUTABLE|url|http://www.mongodb.org/display/DOCS/Advanced%2BQueries#AdvancedQueries-RegularExpressions^0|5|5|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|Z|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|C|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]]]

You could use a <a href="http://www.mongodb.org/display/DOCS/Advanced+Queries#AdvancedQueries-RegularExpressions" rel="noreferrer">regex</a>.

In your example that would be:

<pre class="lang-js prettyprint-override"><code>db.stuff.find( { foo: /^bar$/i } );
</code></pre>

I must say, though, maybe you could just downcase (or upcase) the value on the way in rather than incurring the extra cost every time you find it. Obviously this wont work for people's names and such, but maybe use-cases like tags.

blocks|key|1172416|text|如果您需要从一个变量创建regexp，这是一种更好的方法：https://stackoverflow.com/a/10728069/309514|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1172417|然后，您可以执行以下操作：|1172418|var+string+=+"SomeStringToFind";
var+regex+=+new+RegExp(["%5E",+string,+"$"].join(""),+"i");
//+Creates+a+regex+of:+/%5ESomeStringToFind$/i
db.stuff.find(+{+foo:+regex+}+);|code-block|syntax|javascript|1172419|这样做的好处是更具编程性，或者如果你经常重用它，你可以通过提前编译它来提高性能。|1172420|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/10728069/309514^0|T|17|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|Z|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|C|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]]]

If you need to create the regexp from a variable, this is a much better way to do it: <a href="https://stackoverflow.com/a/10728069/309514">https://stackoverflow.com/a/10728069/309514</a>

You can then do something like:

<pre><code>var string = "SomeStringToFind";
var regex = new RegExp(["^", string, "$"].join(""), "i");
// Creates a regex of: /^SomeStringToFind$/i
db.stuff.find( { foo: regex } );
</code></pre>

This has the benefit be being more programmatic or you can get a performance boost by compiling it ahead of time if you're reusing it a lot.

blocks|key|1172814|text|db.company_profile.find({+"companyName"+:+{+"$regex"+:+"Nilesh"+,+"$options"+:+"i"}});|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1172815|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>db.company_profile.find({ "companyName" : { "$regex" : "Nilesh" , "$options" : "i"}});
</code></pre>

blocks|key|1387811|text|db.zipcodes.find({city+:+"NEW+YORK"});+//+Case-sensitive
db.zipcodes.find({city+:+/NEW+york/i});+//+Note+the+'i'+flag+for+case-insensitivity|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1387812|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>db.zipcodes.find({city : "NEW YORK"}); // Case-sensitive
db.zipcodes.find({city : /NEW york/i}); // Note the 'i' flag for case-insensitivity
</code></pre>

blocks|key|1387923|text|在使用基于正则表达式的查询时，有一件非常重要的事情要记住--当你对登录系统执行这个操作时，你要搜索的escape+every+single+character，不要忘记%5E和$运算符。Lodash+has+a+nice+function+for+this，你是否已经在使用它了：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1387924|db.stuff.find({$regex:+new+RegExp(_.escapeRegExp(bar),+$options:+'i'})|code-block|syntax|javascript|1387925|为什么？假设一个用户输入.*作为他的用户名。这将匹配所有用户名，只需猜测任何用户的密码即可登录。|style|CODE|1387926|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/3561493/is-there-a-regexp-escape-function-in-javascript|1|https://lodash.com/docs#escapeRegExp^0|1E|T|0|2J|Z|1|0|0|C|2|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]|$A|10|B|11|1|12]]|C|$]]|$1|D|3|E|5|F|7|13|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|14|8|@$A|15|B|16|K|L]]|9|@]|C|$]]|$1|M|3|-4|5|6|7|17|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]|U|$5|P|Q|R|C|$S|V]]]]

One very important thing to keep in mind when using a Regex based query - When you are doing this for a login system, <a href="https://stackoverflow.com/questions/3561493/is-there-a-regexp-escape-function-in-javascript">escape every single character</a> you are searching for, and don't forget the ^ and $ operators. <a href="https://lodash.com/docs#escapeRegExp" rel="noreferrer">Lodash has a nice function for this</a>, should you be using it already:

<pre><code>db.stuff.find({$regex: new RegExp(_.escapeRegExp(bar), $options: 'i'})
</code></pre>

Why? Imagine a user entering <code>.*</code> as his username. That would match all usernames, enabling a login by just guessing any user's password.

blocks|key|1387701|text|Mongo+(当前版本2.0.0)不允许对索引字段进行不区分大小写的搜索-请参阅their+documentation。对于非索引字段，其他答案中列出的正则表达式应该没问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1387702|entityMap|0|LINK|mutability|MUTABLE|url|http://www.mongodb.org/display/DOCS/Indexes#Indexes-AdditionalNotesonIndexes^0|14|J|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Mongo (current version 2.0.0) doesn't allow case-insensitive searches against indexed fields - see <a href="http://www.mongodb.org/display/DOCS/Indexes#Indexes-AdditionalNotesonIndexes">their documentation</a>. For non-indexed fields, the regexes listed in the other answers should be fine.

blocks|key|1388151|text|用于搜索变量并对其进行转义：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1388152|const+escapeStringRegexp+=+require('escape-string-regexp')
const+name+=+'foo'
db.stuff.find({name:+new+RegExp('%5E'+%2B+escapeStringRegexp(name)+%2B+'$',+'i')})+++|code-block|syntax|javascript|1388153|对变量进行转义可以保护查询免受'.*‘或其他正则表达式的攻击。|1388154|escape-string-regexp|offset|length|1388155|entityMap|0|LINK|mutability|MUTABLE|url|https://www.npmjs.com/package/escape-string-regexp^0|0|0|0|0|K|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|X|8|@]|9|@$K|Y|L|Z|1|10]]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

For searching a variable and escaping it:

<pre><code>const escapeStringRegexp = require('escape-string-regexp')
const name = 'foo'
db.stuff.find({name: new RegExp('^' + escapeStringRegexp(name) + '$', 'i')}) 
</code></pre>

Escaping the variable protects the query against attacks with '.*' or other regex. 

<a href="https://www.npmjs.com/package/escape-string-regexp" rel="noreferrer">escape-string-regexp</a>

blocks|key|1387871|text|假设你想在“表”中搜索“列”，并且你想要不区分大小写的搜索。最好且有效的方法是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1387872|//create+empty+JSON+Object
mycolumn+=+{};

//check+if+column+has+valid+value
if(column)+{
++++mycolumn.column+=+{$regex:+new+RegExp(column),+$options:+"i"};
}
Table.find(mycolumn);|code-block|syntax|javascript|1387873|它只是将您的搜索值添加为RegEx，并使用以"i“为选项设置的不敏感条件进行搜索。|1387874|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Suppose you want to search &quot;column&quot; in &quot;Table&quot; and you want case insensitive search. The best and efficient way is:
<pre><code>//create empty JSON Object
mycolumn = {};

//check if column has valid value
if(column) {
 mycolumn.column = {$regex: new RegExp(column), $options: &quot;i&quot;};
}
Table.find(mycolumn);
</code></pre>
It just adds your search value as RegEx and searches in with insensitive criteria set with &quot;i&quot; as option.

blocks|key|1387617|text|最好的方法是使用您选择的语言，在为您的对象创建模型包装器时，让save()方法迭代一组字段，您将在这些字段上搜索这些字段，这些字段也被索引；这些字段集应该具有小写的副本，然后用于搜索。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1387618|每次再次保存对象时，都会检查小写属性，并使用对主属性的任何更改来更新这些属性。这将使您可以有效地搜索，但隐藏每次更新lc字段所需的额外工作。|1387619|小写的字段可以是key:value对象存储，或者只是带有前缀lc_的字段名称。我使用第二种方法来简化查询(深度对象查询有时会让人感到困惑)。|1387620|注意:您希望索引lc_字段，而不是它们所基于的主要字段。|1387621|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

The best method is in your language of choice, when creating a model wrapper for your objects, have your save() method iterate through a set of fields that you will be searching on that are also indexed; those set of fields should have lowercase counterparts that are then used for searching.

Every time the object is saved again, the lowercase properties are then checked and updated with any changes to the main properties. This will make it so you can search efficiently, but hide the extra work needed to update the lc fields each time.

The lower case fields could be a key:value object store or just the field name with a prefixed lc_. I use the second one to simplify querying (deep object querying can be confusing at times). 

Note: you want to index the lc_ fields, not the main fields they are based off of.

blocks|key|1387764|text|使用Mongoose，这对我很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1387765|var+find+=+function(username,+next){
++++User.find({'username':+{$regex:+new+RegExp('%5E'+%2B+username,+'i')}},+function(err,+res){
++++++++if(err)+throw+err;
++++++++next(null,+res);
++++});
}|code-block|syntax|javascript|1387766|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Using Mongoose this worked for me:

<pre><code>var find = function(username, next){
 User.find({'username': {$regex: new RegExp('^' + username, 'i')}}, function(err, res){
 if(err) throw err;
 next(null, res);
 });
}
</code></pre>

blocks|key|1172682|text|聚合框架是在mongodb+2.2中引入的。您可以使用字符串运算符"$strcasecmp“在字符串之间进行不区分大小写的比较。它比使用正则表达式更推荐，也更容易。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1172683|下面是关于聚合命令运算符https://docs.mongodb.com/manual/reference/operator/aggregation/strcasecmp/#exp._S_strcasecmp的官方文档。|offset|length|1172684|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.mongodb.com/manual/reference/operator/aggregation/strcasecmp/#exp._S_strcasecmp^0|0|C|2K|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

The aggregation framework was introduced in mongodb 2.2 . You can use the string operator "$strcasecmp" to make a case-insensitive comparison between strings. It's more recommended and easier than using regex.

Here's the official document on the aggregation command operator: <a href="https://docs.mongodb.com/manual/reference/operator/aggregation/strcasecmp/#exp._S_strcasecmp" rel="nofollow noreferrer">https://docs.mongodb.com/manual/reference/operator/aggregation/strcasecmp/#exp._S_strcasecmp</a> .

blocks|key|1172718|text|在C#中使用过滤器对我来说很有效。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1172719|string+s+=+"searchTerm";
++++var+filter+=+Builders<Model>.Filter.Where(p+=>+p.Title.ToLower().Contains(s.ToLower()));
++++++++++++++++var+listSorted+=+collection.Find(filter).ToList();
++++++++++++++++var+list+=+collection.Find(filter).ToList();|code-block|syntax|javascript|1172720|它甚至可能使用索引，因为我相信这些方法是在返回之后调用的，但我还没有测试过这一点。|1172721|这也避免了以下问题|1172722|var+filter+=+Builders<Model>.Filter.Eq(p+=>+p.Title.ToLower(),+s.ToLower());|1172723|mongodb会认为p.Title.ToLower()是一个属性，不会正确映射。|1172724|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|U|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

Using a filter works for me in C#.

<pre><code>string s = "searchTerm";
 var filter = Builders&lt;Model&gt;.Filter.Where(p =&gt; p.Title.ToLower().Contains(s.ToLower()));
 var listSorted = collection.Find(filter).ToList();
 var list = collection.Find(filter).ToList();
</code></pre>

It may even use the index because I believe the methods are called after the return happens but I haven't tested this out yet.

This also avoids a problem of 

<pre><code>var filter = Builders&lt;Model&gt;.Filter.Eq(p =&gt; p.Title.ToLower(), s.ToLower());
</code></pre>

that mongodb will think p.Title.ToLower() is a property and won't map properly.

blocks|key|1172755|text|我也遇到过类似的问题，这就是对我有效的方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1172756|++const+flavorExists+=+await+Flavors.findOne({
++++'flavor.name':+{+$regex:+flavorName,+$options:+'i'+},
++});|code-block|syntax|javascript|1172757|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I had faced a similar issue and this is what worked for me:

<pre><code> const flavorExists = await Flavors.findOne({
 'flavor.name': { $regex: flavorName, $options: 'i' },
 });
</code></pre>

blocks|key|1387797|text|我为不区分大小写的正则表达式创建了一个简单的Func，我在我的过滤器中使用它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1387798|private+Func<string,+BsonRegularExpression>+CaseInsensitiveCompare+=+(field)+=>+
++++++++++++BsonRegularExpression.Create(new+Regex(field,+RegexOptions.IgnoreCase));|code-block|syntax|javascript|1387799|然后，您只需按如下方式对字段进行筛选。|1387800|db.stuff.find({"foo":+CaseInsensitiveCompare("bar")}).count();|1387801|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I've created a simple Func for the case insensitive regex, which I use in my filter.

<pre><code>private Func&lt;string, BsonRegularExpression&gt; CaseInsensitiveCompare = (field) =&gt; 
 BsonRegularExpression.Create(new Regex(field, RegexOptions.IgnoreCase));
</code></pre>

Then you simply filter on a field as follows.

<pre><code>db.stuff.find({"foo": CaseInsensitiveCompare("bar")}).count();
</code></pre>

blocks|key|1387999|text|它们已经针对字符串搜索进行了测试|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1388000|{'_id':+/.*CM.*/}+++++++++++++++%7C%7Cfind+_id+where+_id+contains+++->CM
{'_id':+/%5ECM/}++++++++++++++++++%7C%7Cfind+_id+where+_id+starts+++++->CM
{'_id':+/CM$/}++++++++++++++++++%7C%7Cfind+_id+where+_id+ends+++++++->CM

{'_id':+/.*UcM075237.*/i}+++++++%7C%7Cfind+_id+where+_id+contains+++->UcM075237,+ignore+upper/lower+case
{'_id':+/%5EUcM075237/i}++++++++++%7C%7Cfind+_id+where+_id+starts+++++->UcM075237,+ignore+upper/lower+case
{'_id':+/UcM075237$/i}++++++++++%7C%7Cfind+_id+where+_id+ends+++++++->UcM075237,+ignore+upper/lower+case|code-block|syntax|javascript|1388001|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

These have been tested for string searches

<pre><code>{'_id': /.*CM.*/} ||find _id where _id contains -&gt;CM
{'_id': /^CM/} ||find _id where _id starts -&gt;CM
{'_id': /CM$/} ||find _id where _id ends -&gt;CM

{'_id': /.*UcM075237.*/i} ||find _id where _id contains -&gt;UcM075237, ignore upper/lower case
{'_id': /^UcM075237/i} ||find _id where _id starts -&gt;UcM075237, ignore upper/lower case
{'_id': /UcM075237$/i} ||find _id where _id ends -&gt;UcM075237, ignore upper/lower case
</code></pre>

blocks|key|1172848|text|适用于任何使用Golang并希望使用mongodb和mgo+godoc+globalsign+library进行区分大小写的全文搜索的用户。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1172849|collation+:=+&mgo.Collation{
++++Locale:+++"en",
++++Strength:+2,+
}


err+:=+collection.Find(query).Collation(collation)|code-block|syntax|javascript|1172850|entityMap|0|LINK|mutability|MUTABLE|url|https://godoc.org/github.com/globalsign/mgo#Collation^0|U|O|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

For any one using Golang and wishes to have case sensitive full text search with mongodb and the mgo <a href="https://godoc.org/github.com/globalsign/mgo#Collation" rel="nofollow noreferrer">godoc globalsign library</a>.

<pre><code>collation := &amp;mgo.Collation{
 Locale: "en",
 Strength: 2, 
}


err := collection.Find(query).Collation(collation)
</code></pre>

blocks|key|1387970|text|正如你在mongo文档中所看到的--从3.2版本开始，$text索引默认是不区分大小写的：https://docs.mongodb.com/manual/core/index-text/#text-index-case-insensitivity|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1387971|Create+a+text+index和use+$text+operator+in+your+query。|1387972|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.mongodb.com/manual/core/index-text/#text-index-case-insensitivity|1|https://docs.mongodb.com/manual/core/index-text/#create-text-index|2|https://docs.mongodb.com/manual/reference/operator/query/text/#op._S_text^0|R|5|19|26|0|0|0|J|1|K|W|2|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@$9|W|A|X|1|Y]]|E|$]]|$1|F|3|G|5|6|7|Z|8|@]|D|@$9|10|A|11|1|12]|$9|13|A|14|1|15]]|E|$]]|$1|H|3|-4|5|6|7|16|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]|P|$5|K|L|M|E|$N|Q]]|R|$5|K|L|M|E|$N|S]]]]

As you can see in mongo docs - since version 3.2 <code>$text</code> index is case-insensitive by default: <a href="https://docs.mongodb.com/manual/core/index-text/#text-index-case-insensitivity" rel="nofollow noreferrer">https://docs.mongodb.com/manual/core/index-text/#text-index-case-insensitivity</a> 

<a href="https://docs.mongodb.com/manual/core/index-text/#create-text-index" rel="nofollow noreferrer">Create a text index</a> and <a href="https://docs.mongodb.com/manual/reference/operator/query/text/#op._S_text" rel="nofollow noreferrer">use $text operator in your query</a>.

Example:

<pre><code>&gt; db.stuff.save({"foo":"bar"});

&gt; db.stuff.find({"foo":"bar"}).count();
1
&gt; db.stuff.find({"foo":"BAR"}).count();
0
</code></pre>

MongoDB: Is it possible to make a case-insensitive query?

对象存储

JSON

示例：> db.stuff.save({"foo":"bar"});> db.stuff.find({"foo":"bar"}).count();1> db.stuff.find({"foo":"BAR"}).count();0

问MongoDB:可以进行不区分大小写的查询吗？
EN

回答 17

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MongoDB:可以进行不区分大小写的查询吗？EN

回答 17

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MongoDB:可以进行不区分大小写的查询吗？
EN