MongoDB search multiple fields matching parts of a string

Question

Here is a challenge to my fellows MongoDB and NodeJs Devs

I have a search form, in which a user can enter the following:

225/65R16 71T K715 Hankook

As for my mongodb, I have a collection with the following docs:

1- { _id: SomeId, Description: 225/65R16 71T K715, Brand: Hankook, Ref: 123455 }
2- { _id: SomeId, Description: 225/65R16 71T K715, Brand: Continental, Ref: 123456 }
3- { _id: SomeId, Description: 225/65R16 94T Energy, Brand: Hankook, Ref: 123457 }

How can I do that so that when searching any combination below I get results for the docs 1 and 3 above?

List of combinations:

Hankook
225/65R16
225/65R16 Hankook
225 Hankook
225 Han

Not possible for that list of combinations: 71T is in document #2. Also, there's no way that would match on document #3. However, if you're looking to do a search in the manor it appears you are, you should look into text search indexes. Here's a good article: code.tutsplus.com/tutorials/… — Randy
– Randy, Commented Nov 18, 2016 at 2:22
Edited the question as the last 2 items I had in the list was a bad example. I guess a better question is how to search for values that match either or in two fields (description and brand) — Juan Gonzales
– Juan Gonzales, Commented Nov 18, 2016 at 2:42
You can use the $or operator: docs.mongodb.com/v3.2/reference/operator/query/or — Randy
– Randy, Commented Nov 18, 2016 at 2:43

Eros Hernández · Accepted Answer · 2016-11-18 03:05:59Z

2

You can try by creating an Index:

db.yourollection.createIndex({"Description":1,"Brand":1})

And then by searching for the value, Example:

mongoosemodel.find({$text:{$search: 225/65R16 Hankook}},{Description:1,Brand:1})

And, if you get more results than expected, you can make a filter by using Javascript.

answered Nov 18, 2016 at 3:05

Eros Hernández

561 silver badge6 bronze badges

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

1 Comment

Randy Over a year ago

Probably the best answer. Regex will work as pointed out by the other answers, but it's not scalable as it doesn't utilize your indexes. So the larger your tire collection becomes, the slow these queries will become.

cjungel · Accepted Answer · 2016-11-18 12:38:44Z

You can use regular expressions to match the beginning of the fields and then use OR operator.

Assuming the following documents.

{ "Description" : "225/65R16 71T K715", "Brand" : "Hankook", "Ref" : 123455 }
{ "Description" : "225/65R16 71T K715", "Brand" : "Continental", "Ref" : 123455 }
{ "Description" : "225/65R16 94T", "Brand" : "Hankook", "Ref" : 123455 }

The following queries return the expected results.

> db.test.find({$or: [{Description: {$regex: '^225/65R16'}, Brand: {$regex: '^Hankook'}}]})
{ "Description" : "225/65R16 71T K715", "Brand" : "Hankook", "Ref" : 123455 }
{"Description" : "225/65R16 94T", "Brand" : "Hankook", "Ref" : 123455 }

> db.test.find({$or: [{Description: {$regex: '^225'}, Brand: {$regex: '^Han'}}]})
{ "Description" : "225/65R16 71T K715", "Brand" : "Hankook", "Ref" : 123455 }
{ "Description" : "225/65R16 94T", "Brand" : "Hankook", "Ref" : 123455 }

For 225/65R16 though there's no way to avoid matching document number 2 beacuse the query does not contain enough disambiguation information.

Rami Mohamed · Accepted Answer · 2020-02-21 10:54:00Z

1

Here is an example based on a node.js, javascript and mongoose

you can look for a "search word" or "search term" in multiple fields in a collection like so :

var searchTerm = 'Hankook'; // put your search term here

YourMongooseModel.find({ 
    $or: [
        // in this example we want to search at two fields 'Description' and 'Brand'
        // however you can put any fields as you desire
        {"Description": {$regex: searchTerm, $options: "i"}},
        {"Brand": {$regex: searchTerm, $options: "i"}}
    ]
}, function (err, docs) {
    if(docs) {
        // handle retreived docs here
    }
});

Hope this helps. Thanks

edited Feb 21, 2020 at 10:54

answered Feb 21, 2020 at 10:46

Rami Mohamed

2,8056 gold badges29 silver badges35 bronze badges

Comments

Daphoque · Accepted Answer · 2016-11-18 13:41:07Z

Use aggregation to concat search fields, then simply use a regex :

// Build a regex from your string,
// Example : containing exactly all word, no order
enter code here
var a = "225/65R16 71T K715 Hankook"
var ar = a.split(new RegExp("\\s")); // [ '225/65R16', '71T', 'K715', 'Hankook' ]
var estr = ""
ar.forEach(function(e){ estr += "(?=.*\b"+e+"\b)";});
var re = new RegExp("^.*"+estr+".*$"); // /^.*(?=.*\b225\/65R16\b)(?=.*\b71T\b)(?=.*\bK715\b)(?=.*\bHankook\b).*$/



enter code here
db.a.aggregate([
   {
       $project:{
          st: {$concat:["$Brand"," ", "$Description"]}, 
         _id:1,
         Description:1,
         Brand:1,
         Ref:1
       }
   },
   {
      $match:{
         st: /^(?=.*\b225\/65R16\b)(?=.*\b71T\b)(?=.*\bK715\b)(?=.*\bHankook\b).*$/
      }
   }
])

// output { "_id" : ObjectId("582f009da52585177f054ddc"), "Description" : "225/65R16 71T K715", "Brand" : "Hankook", "Ref" : "123455", "st" : "Hankook 225/65R16 71T K715" }

Collectives™ on Stack Overflow

MongoDB search multiple fields matching parts of a string

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related