MongoDB Text Search AND multiple search words

Question

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 1

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.

Answer 2

You can wrap each word in double-quotes:

let keywords = ctx.params.query.split(/\s+/).map(kw => `"${kw}"`).join(' '); match.$text = { $search: keywords, $caseSensitive: false }; 

There is a downside if the user inputs a quoted string this will not work. You'd have to parse out quoted strings first.