Question

Views

I have a mongodb collection with documents structured like this

{
   ...
   "ownerName":"Bob",   
   "city":"Oregon",
   "refNote":"sadkj1233233@qwertz",
}

I want to filter and select only documents where refNote not ends with @qwertz

over 4 years ago · Santiago Trujillo

Answer question

Accepted Answer · 2022-05-12T20:24:17.362Z

You can use regular expression and $not operator,

$regex to pass string that you want to search, specify $ at the end of string to search exact from end of the string,
$not to check opposit condition

db.collection.find({
  refNote: {
    $not: {
      $regex: "@qwertz$"
    }
  }
})