How to check if a value exists anywhere in an entire MongoDB collection?

Asked Jul 30 '19 at 14:57

Active Jul 30 '19 at 15:03

Viewed 184 times

I know you could do Coll.findOne({ email_1: '[email protected]' }) to look up [email protected] against the field email_1 in collection Coll. However, what if there were several email fields (email_1, email_2, email_3, etc.) and I needed to look up a given email against all those fields?

I could reiterate Coll.findOne({ email_1: '[email protected]' }) for each field in my collection but that obviously isn't most optimal.

asked Jul 30 '19 at 14:57

TheLearner

2,813
5
46
94

2

A similar question like your. [Just look it] (https://stackoverflow.com/questions/6790819/searching-for-value-of-any-field-in-mongodb-without-explicitly-naming-it). May be helpful. – Nasir Kamal Jul 30 '19 at 15:06
1

As far as I know I'm not aware of anything, unless we do it in code. Interested to learn if someone has a query solution. – whoami - fakeFaceTrueSoul Jul 30 '19 at 15:09
1

I believe that, if possible in your case, the best way would be changing the schema to something like `"emails": ["[email protected]","[email protected]","[email protected]"]` – Caconde Jul 30 '19 at 15:09
Possible duplicate of [Searching for value of any field in MongoDB without explicitly naming it](https://stackoverflow.com/questions/6790819/searching-for-value-of-any-field-in-mongodb-without-explicitly-naming-it) – TheLearner Jul 30 '19 at 15:18

How to check if a value exists anywhere in an entire MongoDB collection?

0 Answers0