MongoDB Text Search AND multiple search words

mongodb full-text-search
kmehta picture kmehta · Jun 3, 2013 · Viewed 23.2k times · Source

I have an index on an array "keys" that I am using to provide full text functionality to my applicaiton.

With the release of 2.4.3, I'd like to utilize the "text" index type. I insured a "text" index type on my array "keys" and it seems to work SUPER fast (faster than my old keywords full text method).

The problem is, my app assumes that fields are inclusive (AND). By default, the text search ORs my parameters.

Does anyone know of a way to run a text search inclusively?

For example:

db.supplies.runCommand("text", {search:"printer ink"})

should return results with both printer and ink, instead of all results with either printer or ink.

Answer

alecxe picture alecxe · Jun 3, 2013

Give a try to:

db.supplies.runCommand("text", {search:"\"printer\" \"ink\""})

Also, here's a quote from docs:

If the search string includes phrases, the search performs an AND with any other terms in the search string; e.g. search for "\"twinkle twinkle\" little star" searches for "twinkle twinkle" and ("little" or "star").

Hope that helps.

Related questions

Full text search with weight in mongoose

As I find out, since version 3.8.9, mongoose support full text search. But I can't find a good documentation for it! I want to do something like: db.collection.ensureIndex( // Fields to index { animal: "text", color: "text", pattern: "text", size: "text" }, // …

Read More
MongoDB fulltext search + workaround for partial word match

Since it is not possible to find "blueberry" by the word "blue" by using a mongodb full text search, I want to help my users to complete the word "blue" to "blueberry". To do so, is it possible to query …

Read More
Invalid parameter index! You seem to have declare too little query method parameters! - Spring Mongo TextSearch

I am developing Spring + Mongo Data JPA example for Text Search. When I am trying to search using OrderID 102. I was expecting all records to be fetch from DB those record contains 102 in OrderID. Please help me I see following …

Read More