Search for multiple words/substrings in a string using MongoDB Queries?

Question

I have a model as shown

[
    {"_id": "1", "Title": "boat test"},
    {"_id": "2", "Title": "mobiles and extras"}
]

Query_String = "boat" // should return [{"_id": "1", "Title": "boat test"}]

Query_String = "boat te" // should return [{"_id": "1", "Title": "boat test"}]

Query_String = "mobiles" // should return [{"_id": "2", "Title": "mobiles and extras"}]

Query_String = "mob" // should return [{"_id": "2", "Title": "mobiles and extras"}]

Query_String = "boat mobile" // should return [{"_id": "1", "Title": "boat test"}, {"_id": "2", "Title": "mobiles and extras"}]

My query is to get all products whose "Title" field has any of the words in a given Query_String

I tried this but this works for 1st case only in which Query_String is "boat"

const { Products } = require("../models/Products");

Products.find({
      Title: {
        $regex: `.*${Query_String}.*`,
        $options: "i",
      },
    })

turivishal · Accepted Answer · 2021-03-02 08:38:32Z

2

There are 2 approaches,

Using javascript RegExp:

split string by space and make array, map to convert string to regular express
Try $in Expressions, To include a regular expression in an $in query expression, you can only use JavaScript regular expression objects (i.e. /pattern/ ). For example:

let QString = Query_String.split(" ").map(s => new RegExp(s));
Products.find({
  $or: [
    { Title: { $in: QString } },
    // more fields if needed
    { Category: { $in: QString } }
  ]  
});

Using $or conditional and $regex

split string by space and make array, map to prepare array of separate conditions
check $or condition

let QStringTitle = Query_String.split(" ").map(s => { 
  return {
    {
      Title: {
        $regex: s,
        $options: "i"
      }
    }
  };
});
let QStringCategory = Query_String.split(" ").map(s => { 
  return {
    {
      Category: {
        $regex: s,
        $options: "i"
      }
    }
  };
});
Products.find({ $or: QStringTitle.concat(QStringCategory) });

edited Mar 2, 2021 at 8:38

answered Mar 1, 2021 at 18:55

turivishal

36.4k7 gold badges48 silver badges69 bronze badges

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

3 Comments

Kartikey Over a year ago

I tried this out and it worked out prefectly fine...

let TitleFilter = req.body.Title.split(" ").map((s) => {       return {         Title: {           $regex: s,           $options: "i",         },       };     });

const product = await Products.find({ $or: TitleFilter }); // this returned output as expected but what if I want to also check Category Field for the same query.... For ex right now I am checking Just for Title field..what if I want to check for Title and Category field both at the same time...i.e; for Multiple fields.

turivishal Over a year ago

I have updated the answer with category condition.

Kartikey Over a year ago

I used the second approach for my problem. It works Perfectly fine. Thanks! We can use the spread operator also here just to concat the two arars like this.. [...TitleFilter, ...CategoryFilter]

Collectives™ on Stack Overflow

Search for multiple words/substrings in a string using MongoDB Queries?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related