How to use regex in MongoDB $ne condition

Question

I am trying to query my collection where a particular field does not match a given regex. I am trying with the following query

```sh
db.getCollection('users').find({email: {$ne: /^.*gmail\.com$/}})
```

But I am getting following error

```javascript
Error: error: {
	"ok" : 0,
	"errmsg" : "Can't have regex as arg to $ne.",
	"code" : 2,
	"codeName" : "BadValue"
}

```

Karthik Divi · Accepted Answer

You can use `$regex and $not` to perform your query.

Try the following

```sh
db.getCollection('users').find({email:  {$not: /^.*gmail\.com$/ } })
```

1 Answer