Mongoose find with multiple values for a field

Question

Select * from table_name where sport_type LIKE ('Cricket','Football');

I am trying to find the documents with sport_typeof Cricket and Football using find

table.find({ sport_type : "Cricket" })

Can anyone help me to do so

Is there a reason in your SQL example that you're using LIKE instead of IN? — JohnnyHK
– JohnnyHK, Commented Nov 12, 2016 at 14:07
Does this answer your question? mongodb/mongoose findMany - find all documents with IDs listed in array — Mir-Ismaili
– Mir-Ismaili, Commented Sep 14, 2020 at 2:26

Divyanshu Maithani · Accepted Answer · 2016-11-12 14:07:56Z

3

Try using $or:

table.find( { $or:[ {'sport_type':'Cricket'}, {'sport_type':'Football'} ]}, 
  function(err,docs){
    // do something
});

answered Nov 12, 2016 at 14:07

Divyanshu Maithani

15.1k2 gold badges39 silver badges48 bronze badges

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

2 Comments

hzitoun Over a year ago

the equivalent of your answer is Select * from table_name where sport_type = 'Cricket' or sport_type = 'Football';. He looks for a LIKE comparison.

Divyanshu Maithani Over a year ago

@Mitchapp the OP is trying to find documents with sport_type of Cricket or Football. I don't think he is looking for a pattern.

Rodolfo Dassaev · Accepted Answer · 2021-09-16 17:25:59Z

3

Maybe it's too late to answer but hopefully it will help other people.

You can use $in operator, like this:

mongoose.find({sport_type: {$in: ['Cricket', 'Football']}})

You provide an array to $in operator and it will return all the documents which have an exact sport_type in the array specified.

answered Sep 16, 2021 at 17:25

Rodolfo Dassaev

714 bronze badges

Collectives™ on Stack Overflow

Mongoose find with multiple values for a field

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related