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?

score 69 · Accepted Answer · edited Mar 18 '14 at 18:40

69

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 '14 at 18:40

answered Apr 09 '11 at 23:27

Brendan W. McAdams

9,379
3
41
31

+1 literally saved my sanity. I have been searching how to do some negative regex , as the $not operator does not except $regex – kommradHomer Jul 27 '15 at 15:32

score 4 · Answer 2 · edited May 23 '17 at 12:09

4

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 '17 at 12:09

Community

1
1

answered Feb 02 '16 at 12:22

Nachshon Schwartz

15,289
20
59
98

score 4 · Answer 3 · answered Sep 10 '16 at 04:19

4

To make it case insensitive:

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

answered Sep 10 '16 at 04:19

Andres

1,090
14
30

score 1 · Answer 4 · answered Apr 28 '15 at 07:48

1

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 '15 at 07:48

Vaibhav

2,073
4
23
26

score 1 · Answer 5 · answered Aug 26 '16 at 08:42

1

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

answered Aug 26 '16 at 08:42

evan.wang

11
2

score 0 · Answer 6 · answered Feb 23 '17 at 10:05

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);
    }
}

score -1 · Answer 7 · answered Jan 22 '20 at 12:07

-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 '20 at 12:07

Sudheer Kumar Dara

1
1

Hi Sudheer Kumar Dara, welcome. Please consider adding an explanation and formating the code properly. – Tiago Martins Peres Jan 22 '20 at 12:40

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

7 Answers7

Linked