How to make a case-insensitive query in java?

Question

I know make case-insensitive query in console could use regex like db.stuff.find( { foo: /bar/i } );

MongoDB: Is it possible to make a case-insensitive query?

But I cannot fiure out how to use it in java drive.example:

DBObject q = BasicDBObjectBuilder.start().add(type, s).add("user", user).get();
DBCursor cursor = c.find(q);

I want user case-insensitive,How to do that?

You should look here: http://stackoverflow.com/questions/4069340/mongodb-and-java-driver-ignore-case-in-query — lowercase, Jan 29 '12 at 20:33

score 3 · Answer 1 · answered Apr 18 '16 at 22:53

3

You can do it using Pattern.compile() where the first param is the value you are querying for and the second param is Pattern.CASE_INSENSITIVE as below.

query.put("db.variable", Pattern.compile(searchValueHere, Pattern.CASE_INSENSITIVE));

answered Apr 18 '16 at 22:53

stock

117
5

score 0 · Accepted Answer · answered Jan 30 '12 at 01:01

0

You are already aware of using regular expression. The only other option I can think of would be to normalize the data to be queried.

answered Jan 30 '12 at 01:01

Bill

599
4
2

How to make a case-insensitive query in java?

2 Answers2