How to query mongodb with “like” using the java api?

Question

this question is very similar to another post

I basically want to use the mongodb version of the sql "like" '%m%' operator

but in my situation i'm using the java api for mongodb, while the other post is using mongodb shell

i tried what was posted in the other thread and it worked fine

db.users.find({"name": /m/})

but in java, i'm using the put method on the BasicDBObject and passing it into the find() method on a DBCollections object

BasicDBObject q = new BasicDBOBject();
q.put("name", "/"+m+"/");
dbc.find(q);

but this doesn't seem to be working.

anyone has any ideas?

Brendan W. McAdams · Accepted Answer · 2014-03-18 18:40:26Z

70

You need to pass an instance of a Java RegEx (java.util.regex.Pattern):

BasicDBObject q = new BasicDBObject();
q.put("name",  java.util.regex.Pattern.compile(m));
dbc.find(q);

This will be converted to a MongoDB regex when sent to the server, as well as any RegEx flags.

edited Mar 18, 2014 at 18:40

user508434

answered Apr 9, 2011 at 23:27

Brendan W. McAdams

9,4873 gold badges43 silver badges31 bronze badges

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

1 Comment

kommradHomer Over a year ago

+1 literally saved my sanity. I have been searching how to do some negative regex , as the $not operator does not except $regex

Community · Accepted Answer · 2017-05-23 12:09:14Z

6

You must first quote your text and then use the compile to get a regex expression:

q.put("name",  Pattern.compile(Pattern.quote(m)));

Without using java.util.Pattern.quote() some characters are not escaped.

e.g. using ? as the m parameter will throw an exception.

edited May 23, 2017 at 12:09

CommunityBot

11 silver badge

answered Feb 2, 2016 at 12:22

Nachshon Schwartz

15.9k20 gold badges65 silver badges99 bronze badges

Comments

Andres · Accepted Answer · 2016-09-10 04:19:15Z

4

To make it case insensitive:

Document doc = new Document("name", Pattern.compile(keyword, Pattern.CASE_INSENSITIVE));
collection.find(doc);

answered Sep 10, 2016 at 4:19

Andres

1,15415 silver badges31 bronze badges

Comments

Vaibhav · Accepted Answer · 2015-04-28 07:48:15Z

2

In spring data mongodb, this can be done as:

Query query = new Query();
query.limit(10);        
query.addCriteria(Criteria.where("tagName").regex(tagName));
mongoOperation.find(query, Tags.class);

answered Apr 28, 2015 at 7:48

Vaibhav

2,1634 gold badges25 silver badges26 bronze badges

Comments

evan.wang · Accepted Answer · 2016-08-26 08:42:31Z

1

Document doc = new Document("name", Pattern.compile(keyword));
collection.find(doc);

answered Aug 26, 2016 at 8:42

evan.wang

112 bronze badges

Comments

M. Gopal · Accepted Answer · 2017-02-23 10:05:24Z

0

Might not be the actual answer, ( Executing the terminal query directly )

public void displayDetails() {
    try {
        // DB db = roleDao.returnDB();
        MongoClient mongoClient = new MongoClient("localhost", 5000);
        DB db = mongoClient.getDB("test");
        db.eval("db.test.update({'id':{'$not':{'$in':[/su/]}}},{$set:{'test':'test3'}},true,true)", new Object[] {});
        System.out.println("inserted  ");

    } catch (Exception e) {
        System.out.println(e);
    }
}

answered Feb 23, 2017 at 10:05

M. Gopal

4546 silver badges18 bronze badges

Comments

Sudheer Kumar Dara · Accepted Answer · 2020-01-22 12:07:45Z

-1

if(searchType.equals("employeeId")) {

query.addCriteria(Criteria.where(searchType).regex(java.util.regex.Pattern.compile(searchValue)));

employees = mongoOperations.find(query, Employee.class, "OfficialInformation"); }

answered Jan 22, 2020 at 12:07

Sudheer Kumar Dara

11 bronze badge

1 Comment

Tiago Peres Over a year ago

Hi Sudheer Kumar Dara, welcome. Please consider adding an explanation and formating the code properly.

Collectives™ on Stack Overflow

How to query mongodb with “like” using the java api?

7 Answers 7

1 Comment

Comments

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

1 Comment

Comments

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related