How to search by text in Java on Mongo db [duplicate]

Question

How can I write the equivalent of this query for Mongo DB in Java:

db.mydata.find({$where: "this.fields.name.toLowerCase().indexOf('ar') > 0"})

?

The query is used to find all names that include "AR" (martin, mark, etc.).

I am using QueryBuilder at the moment, but it doesn't support that kind of query format.

Any idea?

@Philipp That would be a duplicate if only it actually mentioned how to do it in JAVA — Sammaye
– Sammaye, Commented Nov 21, 2013 at 16:11
Realize that this is going to search every document in the collection if you don't use an anchored regex search (and have an indexed field). Slow. — WiredPrairie
– WiredPrairie, Commented Nov 21, 2013 at 18:07

idbentley · Accepted Answer · 2013-11-21 16:54:23Z

6

An option is to use a Regex instead.

i.e.

Pattern regex = Pattern.compile("ar",  Pattern.CASE_INSENSITIVE | Pattern.UNICODE_CASE);
DBObject query = new DBObject("fields.name", regex);
Cursor result = myCollection.find(query);

edited Nov 21, 2013 at 16:54

answered Nov 21, 2013 at 16:02

idbentley

4,2183 gold badges37 silver badges50 bronze badges

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

1 Comment

Randomize Over a year ago

you are the man! thank you! Just a little correction: new BasicDBObject("fields.name", regex);

Collectives™ on Stack Overflow

How to search by text in Java on Mongo db [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related