mongodb正则$regex命令行简单使用

寂寞烟灰 發表於 2020-5-17 18:50:00

Mongodb正则$regex
正则能帮助我们实现一些复杂的查询，mongodb中实现正也很简单
https://docs.mongodb.com/manual/reference/operator/query/regex/index.html
查询格式
<div class="cnblogs_code">
<pre>{ <field>: { $regex: /pattern/, $options: '<options>' } }
{ <field>: { $regex: 'pattern', $options: '<options>' } }
{ <field>: { $regex: /pattern/<options> } }</pre>
</div>
options可选值
i:不区分大小写
m：如果字符串中包含\n，m会将\n后面的字符也当成一行处理，这对一个字符串中存在多行的情况比较有用
x：忽略字符串中的注释和换行（注释以#开头）？
s：允许点匹配所有字符?
命令行操作
测试数据
<div class="cnblogs_code">
<pre>> db.user_info.insertMany([{"name":"liuqingyun"},{"name":"jeams bean"},{"name":"liuqing"},{"name":"Doc veren"},{"name":"doc jan"},{"name":"yuhuanhuan"},{"name":"liu #ming \n ming"},{"name":"doc liu"},{"name":"DOC jeson"}])</pre>
</div>
1、查询name以包含liu和yu名称
<div class="cnblogs_code">
<pre>db.user_info.find({"name":{"$in":}})</pre>
</div>
<div class="cnblogs_code"><img id="code_img_closed_a6705922-bf55-420a-b918-2dff70678e86" class="code_img_closed lazyload" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif"><img id="code_img_opened_a6705922-bf55-420a-b918-2dff70678e86" class="code_img_opened lazyload" style="display: none" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif">
<div id="cnblogs_code_open_a6705922-bf55-420a-b918-2dff70678e86" class="cnblogs_code_hide">
<pre>> db.user_info.find({"name":{"$in":}})
{ "_id" : ObjectId("5ec101d873e561131511bf15"), "name" : "liuqingyun" }
{ "_id" : ObjectId("5ec101d873e561131511bf17"), "name" : "liuqing" }
{ "_id" : ObjectId("5ec101d873e561131511bf1a"), "name" : "yuhuanhuan" }
{ "_id" : ObjectId("5ec101d873e561131511bf1b"), "name" : "liu #ming \n ming" }
{ "_id" : ObjectId("5ec101d873e561131511bf1c"), "name" : "doc liu" }</pre>
</div>
View Code</div>
2、查询name以liu和yu开头的名称
<div class="cnblogs_code">
<pre>db.user_info.find({"name":{"$in":[/^liu/,/^yu/]}})</pre>
</div>
<div class="cnblogs_code"><img id="code_img_closed_dcba3f36-58c8-4b41-866a-bc630891627e" class="code_img_closed lazyload" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif"><img id="code_img_opened_dcba3f36-58c8-4b41-866a-bc630891627e" class="code_img_opened lazyload" style="display: none" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif">
<div id="cnblogs_code_open_dcba3f36-58c8-4b41-866a-bc630891627e" class="cnblogs_code_hide">
<pre>> db.user_info.find({"name":{"$in":[/^liu/,/^yu/]}})
{ "_id" : ObjectId("5ec101d873e561131511bf15"), "name" : "liuqingyun" }
{ "_id" : ObjectId("5ec101d873e561131511bf17"), "name" : "liuqing" }
{ "_id" : ObjectId("5ec101d873e561131511bf1a"), "name" : "yuhuanhuan" }
{ "_id" : ObjectId("5ec101d873e561131511bf1b"), "name" : "liu #ming \n ming" }</pre>
</div>
View Code</div>
3、查询name不包含liu和yu字符的名称
<div class="cnblogs_code">
<pre>db.user_info.find({"name":{"$nin":}})</pre>
</div>
<div class="cnblogs_code"><img id="code_img_closed_7f43707c-292b-42bd-99c8-89a0b3a88818" class="code_img_closed lazyload" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif"><img id="code_img_opened_7f43707c-292b-42bd-99c8-89a0b3a88818" class="code_img_opened lazyload" style="display: none" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif">
<div id="cnblogs_code_open_7f43707c-292b-42bd-99c8-89a0b3a88818" class="cnblogs_code_hide">
<pre>> db.user_info.find({"name":{"$nin":}})
{ "_id" : ObjectId("5ec1037873e561131511bf26"), "name" : "jeams bean" }
{ "_id" : ObjectId("5ec1037873e561131511bf28"), "name" : "Doc veren" }
{ "_id" : ObjectId("5ec1037873e561131511bf29"), "name" : "doc jan" }
{ "_id" : ObjectId("5ec1037873e561131511bf2d"), "name" : "DOC jeson" }</pre>
</div>
View Code</div>
4、使用$not查询name不包含liu的字符
<div class="cnblogs_code">
<pre>db.user_info.find({"name":{"$not":/liu/}})</pre>
</div>
<div class="cnblogs_code"><img id="code_img_closed_e99d95cf-758c-4919-a8fa-33169341b651" class="code_img_closed lazyload" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif"><img id="code_img_opened_e99d95cf-758c-4919-a8fa-33169341b651" class="code_img_opened lazyload" style="display: none" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif">
<div id="cnblogs_code_open_e99d95cf-758c-4919-a8fa-33169341b651" class="cnblogs_code_hide">
<pre>> db.user_info.find({"name":{"$not":/liu/}})
{ "_id" : ObjectId("5ec1037873e561131511bf26"), "name" : "jeams bean" }
{ "_id" : ObjectId("5ec1037873e561131511bf28"), "name" : "Doc veren" }
{ "_id" : ObjectId("5ec1037873e561131511bf29"), "name" : "doc jan" }
{ "_id" : ObjectId("5ec1037873e561131511bf2a"), "name" : "yuhuanhuan" }
{ "_id" : ObjectId("5ec1037873e561131511bf2d"), "name" : "DOC jeson" }</pre>
</div>
View Code</div>
或者使用
<div class="cnblogs_code">
<pre>db.user_info.find({"name":{"$not":{"$regex":/liu/}}})</pre>
</div>
<div class="cnblogs_code"><img id="code_img_closed_7ded5bb5-c4c4-4796-b9d7-b896ddd4460d" class="code_img_closed lazyload" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif"><img id="code_img_opened_7ded5bb5-c4c4-4796-b9d7-b896ddd4460d" class="code_img_opened lazyload" style="display: none" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif">
<div id="cnblogs_code_open_7ded5bb5-c4c4-4796-b9d7-b896ddd4460d" class="cnblogs_code_hide">
<pre>> db.user_info.find({"name":{"$not":{"$regex":/liu/}}})
{ "_id" : ObjectId("5ec1037873e561131511bf26"), "name" : "jeams bean" }
{ "_id" : ObjectId("5ec1037873e561131511bf28"), "name" : "Doc veren" }
{ "_id" : ObjectId("5ec1037873e561131511bf29"), "name" : "doc jan" }
{ "_id" : ObjectId("5ec1037873e561131511bf2a"), "name" : "yuhuanhuan" }
{ "_id" : ObjectId("5ec1037873e561131511bf2d"), "name" : "DOC jeson" }</pre>
</div>
View Code</div>
或者使用
<div class="cnblogs_code">
<pre>db.user_info.find({"name":{"$not":{"$regex":"liu"}}}</pre>
</div>
<div class="cnblogs_code"><img id="code_img_closed_e28b6135-9259-4dcc-9bd2-6fade7aa9fff" class="code_img_closed lazyload" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif"><img id="code_img_opened_e28b6135-9259-4dcc-9bd2-6fade7aa9fff" class="code_img_opened lazyload" style="display: none" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif">
<div id="cnblogs_code_open_e28b6135-9259-4dcc-9bd2-6fade7aa9fff" class="cnblogs_code_hide">
<pre>> db.user_info.find({"name":{"$not":{"$regex":"liu"}}})
{ "_id" : ObjectId("5ec1037873e561131511bf26"), "name" : "jeams bean" }
{ "_id" : ObjectId("5ec1037873e561131511bf28"), "name" : "Doc veren" }
{ "_id" : ObjectId("5ec1037873e561131511bf29"), "name" : "doc jan" }
{ "_id" : ObjectId("5ec1037873e561131511bf2a"), "name" : "yuhuanhuan" }
{ "_id" : ObjectId("5ec1037873e561131511bf2d"), "name" : "DOC jeson" }</pre>
</div>
View Code</div>
5、使用$not查询不以liu开头的字符
<div class="cnblogs_code">
<pre>db.user_info.find({"name":{"$not":/^liu/}})</pre>
</div>
<div class="cnblogs_code"><img id="code_img_closed_3c97ea00-e808-4e8b-a181-29a728e7eda5" class="code_img_closed lazyload" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif"><img id="code_img_opened_3c97ea00-e808-4e8b-a181-29a728e7eda5" class="code_img_opened lazyload" style="display: none" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif">
<div id="cnblogs_code_open_3c97ea00-e808-4e8b-a181-29a728e7eda5" class="cnblogs_code_hide">
<pre>> db.user_info.find({"name":{"$not":/^liu/}})
{ "_id" : ObjectId("5ec1037873e561131511bf26"), "name" : "jeams bean" }
{ "_id" : ObjectId("5ec1037873e561131511bf28"), "name" : "Doc veren" }
{ "_id" : ObjectId("5ec1037873e561131511bf29"), "name" : "doc jan" }
{ "_id" : ObjectId("5ec1037873e561131511bf2a"), "name" : "yuhuanhuan" }
{ "_id" : ObjectId("5ec1037873e561131511bf2c"), "name" : "doc liu" }
{ "_id" : ObjectId("5ec1037873e561131511bf2d"), "name" : "DOC jeson" }</pre>
</div>
View Code</div>
或者使用
<div class="cnblogs_code">
<pre>db.user_info.find({"name":{"$not":{"$regex":/^liu/}}})</pre>
</div>
<div class="cnblogs_code"><img id="code_img_closed_7adf7a34-9a57-4a26-841b-85c14abad775" class="code_img_closed lazyload" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif"><img id="code_img_opened_7adf7a34-9a57-4a26-841b-85c14abad775" class="code_img_opened lazyload" style="display: none" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif">
<div id="cnblogs_code_open_7adf7a34-9a57-4a26-841b-85c14abad775" class="cnblogs_code_hide">
<pre>> db.user_info.find({"name":{"$not":{"$regex":/^liu/}}})
{ "_id" : ObjectId("5ec1037873e561131511bf26"), "name" : "jeams bean" }
{ "_id" : ObjectId("5ec1037873e561131511bf28"), "name" : "Doc veren" }
{ "_id" : ObjectId("5ec1037873e561131511bf29"), "name" : "doc jan" }
{ "_id" : ObjectId("5ec1037873e561131511bf2a"), "name" : "yuhuanhuan" }
{ "_id" : ObjectId("5ec1037873e561131511bf2c"), "name" : "doc liu" }
{ "_id" : ObjectId("5ec1037873e561131511bf2d"), "name" : "DOC jeson" }</pre>
</div>
View Code</div>
或者使用
<div class="cnblogs_code">
<pre>db.user_info.find({"name":{"$not":{"$regex":"^liu"}}})</pre>
</div>
<div class="cnblogs_code"><img id="code_img_closed_e75374a7-ddb9-4a96-97fa-e0cce75db3b3" class="code_img_closed lazyload" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif"><img id="code_img_opened_e75374a7-ddb9-4a96-97fa-e0cce75db3b3" class="code_img_opened lazyload" style="display: none" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif">
<div id="cnblogs_code_open_e75374a7-ddb9-4a96-97fa-e0cce75db3b3" class="cnblogs_code_hide">
<pre>> db.user_info.find({"name":{"$not":{"$regex":"^liu"}}})
{ "_id" : ObjectId("5ec1037873e561131511bf26"), "name" : "jeams bean" }
{ "_id" : ObjectId("5ec1037873e561131511bf28"), "name" : "Doc veren" }
{ "_id" : ObjectId("5ec1037873e561131511bf29"), "name" : "doc jan" }
{ "_id" : ObjectId("5ec1037873e561131511bf2a"), "name" : "yuhuanhuan" }
{ "_id" : ObjectId("5ec1037873e561131511bf2c"), "name" : "doc liu" }
{ "_id" : ObjectId("5ec1037873e561131511bf2d"), "name" : "DOC jeson" }</pre>
</div>
View Code</div>
经测试，mongodb的正则表达式中/可以用“代替，这样在java代码调用时也比较容易，如下使用“代替/测试
6、查询name中包含liu的名称
<div class="cnblogs_code">
<pre>db.user_info.find({"name":{"$regex":"liu"}}) </pre>
</div>
<div class="cnblogs_code"><img id="code_img_closed_36d8bdf2-4acf-499a-9600-0d76cf90811d" class="code_img_closed lazyload" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif"><img id="code_img_opened_36d8bdf2-4acf-499a-9600-0d76cf90811d" class="code_img_opened lazyload" style="display: none" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif">
<div id="cnblogs_code_open_36d8bdf2-4acf-499a-9600-0d76cf90811d" class="cnblogs_code_hide">
<pre>> db.user_info.find({"name":{"$regex":"liu"}})
{ "_id" : ObjectId("5ec1037873e561131511bf25"), "name" : "liuqingyun" }
{ "_id" : ObjectId("5ec1037873e561131511bf27"), "name" : "liuqing" }
{ "_id" : ObjectId("5ec1037873e561131511bf2b"), "name" : "liu #ming \n ming" }
{ "_id" : ObjectId("5ec1037873e561131511bf2c"), "name" : "doc liu" }</pre>
</div>
View Code</div>
7、查询name中以liu开头的名称
<div class="cnblogs_code">
<pre>db.user_info.find({"name":{"$regex":"^liu"}})</pre>
</div>
<div class="cnblogs_code"><img id="code_img_closed_4d5885a2-bc38-43b7-ad54-74f8a54c72f5" class="code_img_closed lazyload" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif"><img id="code_img_opened_4d5885a2-bc38-43b7-ad54-74f8a54c72f5" class="code_img_opened lazyload" style="display: none" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif">
<div id="cnblogs_code_open_4d5885a2-bc38-43b7-ad54-74f8a54c72f5" class="cnblogs_code_hide">
<pre>> db.user_info.find({"name":{"$regex":"^liu"}})
{ "_id" : ObjectId("5ec1037873e561131511bf25"), "name" : "liuqingyun" }
{ "_id" : ObjectId("5ec1037873e561131511bf27"), "name" : "liuqing" }
{ "_id" : ObjectId("5ec1037873e561131511bf2b"), "name" : "liu #ming \n ming" }</pre>
</div>
View Code</div>
8、查询name以liu结尾的名称
<div class="cnblogs_code">
<pre>db.user_info.find({"name":{"$regex":"liu$"}})</pre>
</div>
<div class="cnblogs_code"><img id="code_img_closed_b4cd1558-1230-4a2e-ad49-000af373199c" class="code_img_closed lazyload" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif"><img id="code_img_opened_b4cd1558-1230-4a2e-ad49-000af373199c" class="code_img_opened lazyload" style="display: none" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif">
<div id="cnblogs_code_open_b4cd1558-1230-4a2e-ad49-000af373199c" class="cnblogs_code_hide">
<pre>> db.user_info.find({"name":{"$regex":"liu$"}})
{ "_id" : ObjectId("5ec1037873e561131511bf2c"), "name" : "doc liu" }</pre>
</div>
View Code</div>
9、查询包含yu，紧跟着两个huan字符串的名称
<div class="cnblogs_code">
<pre>db.user_info.find({"name":{"$regex":"yu(huan){2}"}})</pre>
</div>
<div class="cnblogs_code"><img id="code_img_closed_79e7bdee-6690-49eb-8b85-88b103eda349" class="code_img_closed lazyload" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif"><img id="code_img_opened_79e7bdee-6690-49eb-8b85-88b103eda349" class="code_img_opened lazyload" style="display: none" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif">
<div id="cnblogs_code_open_79e7bdee-6690-49eb-8b85-88b103eda349" class="cnblogs_code_hide">
<pre>> db.user_info.find({"name":{"$regex":"yu(huan){2}"}})
{ "_id" : ObjectId("5ec1037873e561131511bf2a"), "name" : "yuhuanhuan" }</pre>
</div>
View Code</div>
10、查询name以l开头，g结尾的名称
<div class="cnblogs_code">
<pre>db.user_info.find({"name":{"$regex":"^l.*g$"}})</pre>
</div>
<div class="cnblogs_code"><img id="code_img_closed_2b62f8ee-2c59-4f74-891a-81481ff1a995" class="code_img_closed lazyload" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif"><img id="code_img_opened_2b62f8ee-2c59-4f74-891a-81481ff1a995" class="code_img_opened lazyload" style="display: none" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif">
<div id="cnblogs_code_open_2b62f8ee-2c59-4f74-891a-81481ff1a995" class="cnblogs_code_hide">
<pre>> db.user_info.find({"name":{"$regex":"^l.*g$"}})
{ "_id" : ObjectId("5ec1037873e561131511bf27"), "name" : "liuqing" }</pre>
</div>
View Code</div>
11、查询以doc开头的名称，不区分大小写,mongodb正则默认区分大小写
<div class="cnblogs_code">
<pre>db.user_info.find({"name":{"$regex":"(?i)^doc"}})</pre>
</div>
<div class="cnblogs_code"><img id="code_img_closed_1783147e-fe8c-44a2-ad33-3dc480ce5af4" class="code_img_closed lazyload" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif"><img id="code_img_opened_1783147e-fe8c-44a2-ad33-3dc480ce5af4" class="code_img_opened lazyload" style="display: none" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif">
<div id="cnblogs_code_open_1783147e-fe8c-44a2-ad33-3dc480ce5af4" class="cnblogs_code_hide">
<pre>> db.user_info.find({"name":{"$regex":"(?i)^doc"}})
{ "_id" : ObjectId("5ec1037873e561131511bf28"), "name" : "Doc veren" }
{ "_id" : ObjectId("5ec1037873e561131511bf29"), "name" : "doc jan" }
{ "_id" : ObjectId("5ec1037873e561131511bf2c"), "name" : "doc liu" }
{ "_id" : ObjectId("5ec1037873e561131511bf2d"), "name" : "DOC jeson" }</pre>
</div>
View Code</div>
或者
<div class="cnblogs_code">
<pre>db.user_info.find({"name":{"$regex":/^doc/i}})</pre>
</div>
12、匹配以jeams开头的字符串（正则m字符使用）
在之前数据基础上插入如下数据
<div class="cnblogs_code">
<pre>db.user_info.insertOne({"name":"ming #wang \njeams jan"})</pre>
</div>
<div class="cnblogs_code">
<pre>> db.user_info.find({"name":{"$regex":"^jeams"}})
{ "_id" : ObjectId("5ec1037873e561131511bf26"), "name" : "jeams bean" </pre>
</div>
该命令只返回一行数据
<div class="cnblogs_code">
<pre>> db.user_info.find({"name":{"$regex":"(?m)^jeams"}})
{ "_id" : ObjectId("5ec1037873e561131511bf26"), "name" : "jeams bean" }
{ "_id" : ObjectId("5ec10f7e73e561131511bf2f"), "name" : "ming #wang \njeams jan" }</pre>
</div>
加上正则字符m，返回两行数据，m将\n当成换行符处理。而不是一个普通的字符
13、使用点配置所有字符
文档中讲，使用s可以配置包括换行符在内的所有字符，但是不使用s，似乎也是可以配置到所有字符？
<div class="cnblogs_code">
<pre>> db.user_info.find({"name":{"$regex":"liu.*g"}})
{ "_id" : ObjectId("5ec1037873e561131511bf25"), "name" : "liuqingyun" }
{ "_id" : ObjectId("5ec1037873e561131511bf27"), "name" : "liuqing" }
{ "_id" : ObjectId("5ec1037873e561131511bf2b"), "name" : "liu #ming \n ming" }
>
> db.user_info.find({"name":{"$regex":"(?s)liu.*g"}})
{ "_id" : ObjectId("5ec1037873e561131511bf25"), "name" : "liuqingyun" }
{ "_id" : ObjectId("5ec1037873e561131511bf27"), "name" : "liuqing" }
{ "_id" : ObjectId("5ec1037873e561131511bf2b"), "name" : "liu #ming \n ming" }</pre>
</div>
14、查询name以liu开头，后面跟着4个字符的名称
<div class="cnblogs_code">
<pre> db.user_info.find({"name":{"$regex":"^liu.{4}$"}})</pre>
</div>
<div class="cnblogs_code"><img id="code_img_closed_0860b721-56f3-47ef-a55f-1d94d8432337" class="code_img_closed lazyload" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif"><img id="code_img_opened_0860b721-56f3-47ef-a55f-1d94d8432337" class="code_img_opened lazyload" style="display: none" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif">
<div id="cnblogs_code_open_0860b721-56f3-47ef-a55f-1d94d8432337" class="cnblogs_code_hide">
<pre>> db.user_info.find({"name":{"$regex":"^liu.{4}$"}})
{ "_id" : ObjectId("5ec1037873e561131511bf27"), "name" : "liuqing" }</pre>
</div>
View Code</div>
 15、查询以doc开头全部忽略大小写的名称
<div class="cnblogs_code">
<pre>db.user_info.find({"name":{"$regex":"(?i)^Doc"}})</pre>
</div>
<div class="cnblogs_code"><img id="code_img_closed_53944b85-9fa3-4494-93b2-704ea6ceb1dc" class="code_img_closed lazyload" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif"><img id="code_img_opened_53944b85-9fa3-4494-93b2-704ea6ceb1dc" class="code_img_opened lazyload" style="display: none" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif">
<div id="cnblogs_code_open_53944b85-9fa3-4494-93b2-704ea6ceb1dc" class="cnblogs_code_hide">
<pre>> db.user_info.find({"name":{"$regex":"(?i)^Doc"}})
{ "_id" : ObjectId("5ec1037873e561131511bf28"), "name" : "Doc veren" }
{ "_id" : ObjectId("5ec1037873e561131511bf29"), "name" : "doc jan" }
{ "_id" : ObjectId("5ec1037873e561131511bf2c"), "name" : "doc liu" }
{ "_id" : ObjectId("5ec1037873e561131511bf2d"), "name" : "DOC jeson" }</pre>
</div>
View Code</div>
16、查询以D开头，其他字符忽略大小写的名称
<div class="cnblogs_code">
<pre>db.user_info.find({"name":{"$regex":"^D(?i)oc"}})</pre>
</div>
<div class="cnblogs_code"><img id="code_img_closed_317c1d2c-33ac-4f06-a335-19fa41256f53" class="code_img_closed lazyload" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif"><img id="code_img_opened_317c1d2c-33ac-4f06-a335-19fa41256f53" class="code_img_opened lazyload" style="display: none" alt="" data-src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif">
<div id="cnblogs_code_open_317c1d2c-33ac-4f06-a335-19fa41256f53" class="cnblogs_code_hide">
<pre>> db.user_info.find({"name":{"$regex":"^D(?i)oc"}})
{ "_id" : ObjectId("5ec1037873e561131511bf28"), "name" : "Doc veren" }
{ "_id" : ObjectId("5ec1037873e561131511bf2d"), "name" : "DOC jeson" }</pre>
</div>
View Code</div>
  
来源：https://www.cnblogs.com/qq931399960/p/12906334.html

頁: [1]

琼殿技术论坛's Archiver

mongodb正则$regex命令行简单使用