How do you perform a Case-Insensitive query in node.js implementations of mongodb?

Question

I have a collection containing usernames. If a user searches for "joe", I want it to return "Joe", and any case-different variants (i.e. "jOe", etc.).

I'm using monk to implement mongodb queries in my node.js application - but the documentation has no mention of case insensitive queries, nor does it have any implementation of collations.

I am aware that regex can be used (and works), but it seems to go against the advice of the mongo documentation. Is there a regexless way of doing this in node.js implementations of MongoDB?

I'm unsure as to how I would implement a query like this - Any help would be appreciated.

Looks like a dupe of stackoverflow.com/questions/1863399/…. Lots of options in the answers there. — JohnnyHK
– JohnnyHK, Commented Jan 11, 2020 at 2:00
HI, yes - I've seen these posts and they don't work formally with node.js implementations of mongoDB (namely monk - but also mongoose), as they don't have implementations for collations. The remaining option is regex, which is against mongoDB's advice. — zk-
– zk-, Commented Jan 11, 2020 at 2:04

James · Accepted Answer · 2020-01-11 02:05:22Z

2

MongoDB supports text search - as long as the field has the appropriate index you can leverage the $text operator which supports a caseSensitive option.

answered Jan 11, 2020 at 2:05

James

82.4k19 gold badges172 silver badges245 bronze badges

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

Collectives™ on Stack Overflow

How do you perform a Case-Insensitive query in node.js implementations of mongodb?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related