How can I use 'Not Like' operator in MongoDB How can I use 'Not Like' operator in MongoDB mongodb mongodb

How can I use 'Not Like' operator in MongoDB


From the docs:

The $not operator does not support operations with the $regexoperator. Instead use // or in your driver interfaces, use yourlanguage’s regular expression capability to create regular expressionobjects. Consider the following example which uses the pattern matchexpression //:

db.inventory.find( { item: { $not: /^p.*/ } } )

EDIT (@idbentley):

{$regex: 'ttt'} is generally equivalent to /ttt/ in mongodb, so your query would become:

db.test.find({c: {$not: /ttt/}}

EDIT2 (@KyungHoon Kim):

In python, below one works:

'c':{'$not':re.compile('ttt')}


You can do with regex which does not contain a word. Also, you can use $options => i for case of insensitive search.

Doesn't Contain string

db.collection.find({name:{'$regex' : '^((?!string).)*$', '$options' : 'i'}})

Exact case insensitive string

db.collection.find({name:{'$regex' : '^string$', '$options' : 'i'}})

Starts with string

db.collection.find({name:{'$regex' : '^string', '$options' : 'i'}})

Ends with string

db.collection.find({name:{'$regex' : 'string$', '$options' : 'i'}})

Contains string

db.collection.find({name:{'$regex' : 'string', '$options' : 'i'}})

Keep this as a bookmark, and a reference for any other alterations you may need.http://www.cheatography.com/davechild/cheat-sheets/regular-expressions/