mongodb查询字段对应的数组中包含某个值

<svg xmlns="http://www.w3.org/2000/svg" style="display: none;"><path stroke-linecap="round" d="M5,0 0,2.5 5,5z" id="raphael-marker-block" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"/></svg>

示例一

<pre><code class="lang-javascript hljs"><span class="token punctuation">{</span> id<span class="token punctuation">:</span> <span class="token number">1</span><span class="token punctuation">,</span> arrOne<span class="token punctuation">:</span> <span class="token punctuation">[</span> <span class="token string">"123"</span><span class="token punctuation">,</span> <span class="token string">"456"</span><span class="token punctuation">,</span> <span class="token string">"789"</span> <span class="token punctuation">]</span><span class="token punctuation">,</span> date<span class="token punctuation">:</span> <span class="token string">"2019-09-02"</span> <span class="token punctuation">}</span> </code></pre>

查询语句

<pre><code class="lang-javascript hljs">db<span class="token punctuation">.</span>userinfo<span class="token punctuation">.</span><span class="token function">find</span><span class="token punctuation">(</span><span class="token punctuation">{</span>arrOne<span class="token punctuation">:</span><span class="token punctuation">{</span>$elemMatch<span class="token punctuation">:</span><span class="token punctuation">{</span>$eq<span class="token punctuation">:</span><span class="token string">"123"</span><span class="token punctuation">}</span><span class="token punctuation">}</span><span class="token punctuation">}</span><span class="token punctuation">)</span> </code></pre>

示例二

<pre><code class="lang-javascript hljs"><span class="token punctuation">{</span> id<span class="token punctuation">:</span> <span class="token number">1</span><span class="token punctuation">,</span> arrTwo<span class="token punctuation">:</span> <span class="token punctuation">[</span> <span class="token punctuation">{</span> id<span class="token punctuation">:</span> <span class="token number">1</span><span class="token punctuation">,</span> name<span class="token punctuation">:</span> <span class="token string">"aaa"</span> <span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token punctuation">{</span> id<span class="token punctuation">:</span> <span class="token number">2</span><span class="token punctuation">,</span> name<span class="token punctuation">:</span> <span class="token string">"bbb"</span> <span class="token punctuation">}</span> <span class="token punctuation">]</span><span class="token punctuation">,</span> date<span class="token punctuation">:</span> <span class="token string">"2019-09-02"</span> <span class="token punctuation">}</span> </code></pre>

查询语句

<pre><code class="lang-javascript hljs">db<span class="token punctuation">.</span>userinfo<span class="token punctuation">.</span><span class="token function">find</span><span class="token punctuation">(</span><span class="token punctuation">{</span>arrTwo<span class="token punctuation">:</span><span class="token punctuation">{</span>$elemMatch<span class="token punctuation">:</span><span class="token punctuation">{</span>id<span class="token punctuation">:</span><span class="token number">1</span><span class="token punctuation">}</span><span class="token punctuation">}</span><span class="token punctuation">}</span><span class="token punctuation">)</span> </code></pre> 到此这篇关于“mongodb查询字段对应的数组中包含某个值”的文章就介绍到这了,更多文章或继续浏览下面的相关文章，希望大家以后多多支持JQ教程网！

您可能感兴趣的文章：
NoSQL数据库之MongoDB入门详解
MongoDB高级查询实例分享
安装与配置MongoDB数据
Python3爬虫进阶：MongoDB存储（非关系型数据库）
mongodb查询字段对应的数组中包含某个值
Django中的ORM之查
php标签云制作过程(数据表的结构和查询)
mysql索引使用与优化
有关mysql单表多关键字模糊查询的方法介绍
爬虫数据如何保存到mongoDB？