search records that have special characters in mongoDB

Asked Jan 24 '18 at 10:02

Active Jan 24 '18 at 10:28

Viewed 29 times

I have this kinds of record in mongoDB.which has brackets and other characters.API is also passing same name in parameters. But due to brackets can't search records and can't pass params without brackets. Is there anyway to search exact same records with special characters ?

   {
    "_id": {
        "$oid": "5a67295523aba20014e2fed6"
    },

    "customerName": "X-TERRA EXCAVATING AND GRADING (XTEL6K-27-B-No Tier 2)",  
}

Now my search query in node.js to find customer name is

models.customer.find({ "customerName": { $regex: '.*' + customerName + '.*', $options: 'i' } },
   function(err, data) {
  console.log(data);
 }

But it does not return any record. If I pass customer name without records it return records. What regex should be used to search any kind of names with this special characters ?

edited Jan 24 '18 at 10:28

asked Jan 24 '18 at 10:02

Suraj

That is because your `customerName` contains `(` and `)` that must be escaped in regex. Also, `.*` are redundant. – Wiktor Stribiżew Jan 24 '18 at 10:03
Also, [this](https://stackoverflow.com/a/44570128/3832970) answer might be of help, too. – Wiktor Stribiżew Jan 24 '18 at 10:05
I am passing same customer name as param as it is in db. If I remove ( and ) it won't search anything. @WiktorStribiżew – Suraj Jan 24 '18 at 10:27
Do not remove the parentheses, escape them. – Wiktor Stribiżew Jan 24 '18 at 10:27

search records that have special characters in mongoDB

0 Answers0