How i can insensitive accent an capital letters in agregattion?

Question

I want to make a query that does not discriminate by accents or upper or lower case, i have this:

query && pipeline.unshift({
  '$match': { 'name': { '$regex': new RegExp(query, 'i') } }
})

I tried a lot of regex but i don't know how i can use it, can you help me, please

Answer 1

• $regex add $options : i, case insensitivity to match upper and lower cases.

db.collection.find({
  name: {
    $regex: "sam",
    $options: "i"
  }
})

mongoplayground