StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
9067089
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2012-01-30T16:21:14.270
FavoriteCount
0
LastActivityDate
2012-01-30T16:21:14.270
LastEditDate
LastEditorUserId
0
OwnerUserId
1058503
ParentId
9055492
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
You can use either the $and or the $all operator to do what I believe that you are looking to accomplish. Given your example document: <pre><code>> db.test.find().pretty() { "_id" : ObjectId("4f26b716c27b085280a45a29"), "name" : "Apollo", "text" : "Some text about Apollo moon landings", "keywords" : [ "some", "text", "about", "apollo", "moon", "landings" ] } </code></pre> You can use the $and operator to search for a document whose "keywords" array contains both words. <pre><code>> db.test.find({$and:[{keywords:"apollo"}, {keywords:"landings"}]}) { "_id" : ObjectId("4f26b716c27b085280a45a29"), "name" : "Apollo", "text" : "Some text about Apollo moon landings", "keywords" : [ "some", "text", "about", "apollo", "moon", "landings" ] } > </code></pre> The $all operator will return the same result, and the query is a little more streamlined: <pre><code>> db.test.find({keywords:{$all:["apollo", "landings"]}}) { "_id" : ObjectId("4f26b716c27b085280a45a29"), "name" : "Apollo", "text" : "Some text about Apollo moon landings", "keywords" : [ "some", "text", "about", "apollo", "moon", "landings" ] } </code></pre> If we put an index on the keywords array, both queries make use of it. <pre><code>> db.test.ensureIndex({keywords:1}) > db.test.find({$and:[{keywords:"apollo"}, {keywords:"landings"}]}).explain() { "cursor" : "BtreeCursor keywords_1", "nscanned" : 1, "nscannedObjects" : 1, "n" : 1, "millis" : 0, "nYields" : 0, "nChunkSkips" : 0, "isMultiKey" : true, "indexOnly" : false, "indexBounds" : { "keywords" : [ [ "apollo", "apollo" ] ] } } > db.test.find({keywords:{$all:["apollo", "landings"]}}).explain() { "cursor" : "BtreeCursor keywords_1", "nscanned" : 1, "nscannedObjects" : 1, "n" : 1, "millis" : 0, "nYields" : 0, "nChunkSkips" : 0, "isMultiKey" : true, "indexOnly" : false, "indexBounds" : { "keywords" : [ [ "apollo", "apollo" ] ] } } > </code></pre> Both queries make use of the keywords index. For more information on the different types of queries, please refer to the "Advanced Queries" document. <a href="http://www.mongodb.org/display/DOCS/Advanced+Queries" rel="nofollow">http://www.mongodb.org/display/DOCS/Advanced+Queries</a> For more information on how indexing works in Mongo, please refer to the "Indexing" document. <a href="http://www.mongodb.org/display/DOCS/Indexes#Indexes-IndexingArrayElements" rel="nofollow">http://www.mongodb.org/display/DOCS/Indexes#Indexes-IndexingArrayElements</a> The "Indexing Array Elements" section links to the documentation on MultiKeys. <a href="http://www.mongodb.org/display/DOCS/Multikeys" rel="nofollow">http://www.mongodb.org/display/DOCS/Multikeys</a> If you are unfamiliar with the .explain function of mongodb, it is explained here: <a href="http://www.mongodb.org/display/DOCS/Explain" rel="nofollow">http://www.mongodb.org/display/DOCS/Explain</a> In a nutshell, it displays any indexes that your query is using, and how many documents needed to be accessed in order to return the relevant ones. Finally, your question seems similar to that of another user who was asking about searching for values in arrays earlier this morning. Perhaps this will be relevant to you as well. <a href="http://groups.google.com/group/mongodb-user/browse_thread/thread/38f30a56094d9e3e" rel="nofollow">http://groups.google.com/group/mongodb-user/browse_thread/thread/38f30a56094d9e3e</a> Hopefully, this will help you to write the query that you are looking for. Please let us know if you have any follow-up questions!
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPositional inverted index in MongoDB
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USMarc
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COMy question may be badly written, but the problem I want to solve is that the query should only return results where "apollo" and "landings" are standing next to each other, such as in the phrased query "apollo landings". If I have a text with "apollo xxxx landings" the query should not return it as a result, since it's not a phrase. Is it possible to make such a query?
 singulars
 PostPostId
 PO
 UserUserId
 USfreakshow

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.