Question

Vistas

Im trying to filter in a DDBB in mongoDB Compass all the results that have in "name" any character that is not a letter or a number.

It can be the character alone or with others characters that are valid.

What am I doing wrong?

{ name: {"$regex": "^(?!0-9a-zA-ZÄÖÜäöüß )"} }

about 4 years ago · Juan Pablo Isaza

Responde la pregunta

Accepted Answer · 2022-07-13T09:44:39.095Z

If I've undestood correctly you can use this regex: [^a-zA-Z0-9]:

db.collection.find({
  "name": {
    "$regex": "[^a-zA-Z0-9ÄÖÜäöüß]"
  }
})

Example here