MongoDB - Search string for an element from an array of words

Question

How do i check if a string contains a list of words from an array. I know how do it with one word however how do with an array?

I've tried the following with no luck:

db.getCollection('questions').find( {$text:{$search:{$in: ['chips', 'mars']} }}  )

Any ideas would be appreciated.

Thanks

Alex Blex · Accepted Answer · 2016-02-20 17:05:04Z

3

db.getCollection('questions').find( {$text:{$search:"chips mars" }} ) to find questions with either "chips" or "mars" or both.

db.getCollection('questions').find( {$text:{$search:"\"chips\" \"mars\"" }} ) to find questions with both "chips" and "mars".

Docs for text index search reads:

$search is a string of terms that MongoDB parses and uses to query the text index. MongoDB performs a logical OR search of the terms unless specified as a phrase.

edited Feb 20, 2016 at 17:05

answered Feb 20, 2016 at 16:40

Alex Blex

37.3k7 gold badges53 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

userMod2 Over a year ago

Ah ok, i just need a space between words?

Alex Blex Over a year ago

Yes, I have added a quote from the docs to the answer to make it crystal clear.

Collectives™ on Stack Overflow

MongoDB - Search string for an element from an array of words

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related