Best way to implement case-insensitive queries in MongoDB [duplicate]

Question

What is the best way to implement case-insensitive queries in MongoDB?

For example, A database has a collection of contacts with a first name field. One document has 'Adam' in the first name field, another has 'adam'. What is the best way to query for documents with the first name = 'adam', regardless of the case?

BanksySan · Accepted Answer · 2016-03-29 21:10:49Z

9

Regex is your best bet:

db.collection.find({name: /^adam$/i})

If you're pre-3.2 then you'll need to use the $regex operator:

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

edited Mar 29, 2016 at 21:10

answered Mar 29, 2016 at 20:59

BanksySan

28.7k36 gold badges128 silver badges231 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ggallo · Accepted Answer · 2016-03-29 20:59:38Z

0

db.contacts.find({firstName: /^adam$/i })

answered Mar 29, 2016 at 20:59

ggallo

3481 silver badge11 bronze badges

Collectives™ on Stack Overflow

Best way to implement case-insensitive queries in MongoDB [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related