Case insensitive search in Mongo

Question

I am using a case insensitive search in Mongo, something similar to https://stackoverflow.com/q/5500823/1028488.

ie I am using a regex with options i. But I am having trouble restricting the regex to just that word, it performs more like a 'Like' in SQL

eg: if I use query like {"SearchWord" : { '$regex' : 'win', $options: '-i' }}, it shows me results for win, window & winter. How do i restrict it to jsut show win?

I tried /^win$/ but it's saying invalid JSON... Please suggest away.

Thanks in advance

Answer 1

You can Use $options => i for case insensitive search. Giving some possible examples required for string match.

Exact case insensitive string

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

Contains string

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

Start with string

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

End with string

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

Doesn't 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/

Answer 2

You can use '$regex':'^win$' or /^win$/i (notice no quote on the second one)

Source here : Regex in queries with Mongo