First Name and Last Name Combine search in mongoDB

Question

I have store two field FirstName and LastName stored in MongoDB.from Frontend, I am receiving a string containing both first name and last name separated by space I need a find query which searches both first name & last name combined.

here is eg. scenario

in DB I have following object

{ firstName: "Hemant Kumar", lastName: "Rajpoot" };

if i receive "Hemant Kumar Rajpoot" it should match.If possible please don't give solution with aggregeation.

Answer 1

You can use $regexMatch if you are using latest mongodb version 4.2

db.collection.find({
  "$expr": {
    "$regexMatch": {
      "input": { "$concat": ["$first", " ", "$last"] },
      "regex": "a",  //Your text search here
      "options": "i"
    }
  }
})

MongoPlayground

Answer 2

You can do it with combination of $expr, $eq and $concat.

Example:

db.yourCollection.find({
  $expr: {
    $eq: [
      {$concat: ["$firstName", " ", "$lastName"]}, 
      "Hemant Kumar Rajpoot" // your full name to search here
    ]
  }
})