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

Question

Currently I am using java to connect to MONGODB, I want to write this sql query in mongodb using java driver:

select * from tableA where name like("%ab%")

is their any solution to perform the same task through java, the query in mongodb is very simple i know, the query is

db.collection.find({name:/ab/})

but how to perform same task in java

Current I am using pattern matching to perform the task and code is

DBObject A = QueryBuilder.start("name").is(Pattern.compile("ab", 
                                           Pattern.CASE_INSENSITIVE)).get();

but it makes query very slow I think , does a solution exist that does not use pattern matching?

mjc · Accepted Answer · 2012-04-14 05:10:16Z

1

Can use Regular Expressions. Take a look at the following:

http://www.mongodb.org/display/DOCS/Advanced+Queries#AdvancedQueries-RegularExpressions

Make sure you understand the potential performance impacts!

answered Apr 14, 2012 at 5:10

mjc

3,4363 gold badges38 silver badges47 bronze badges

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

Comments

Hitesh Kumar · Accepted Answer · 2014-02-17 11:48:48Z

0

DBObject A = QueryBuilder.start("name").is(Pattern.compile("ab", 
                                       Pattern.CASE_INSENSITIVE)).get();

I think this is one of the possible solution, you need to create index to achieve those.

answered Feb 17, 2014 at 11:48

Hitesh Kumar

6631 gold badge6 silver badges22 bronze badges

Comments

dash1e · Accepted Answer · 2012-04-14 08:51:42Z

0

Why do you fear the regular expressions? Once the expression is compiled they are very fast, and if the expression is "ab" the result is similar to a function that search a substring in a string.

However to do what you need you have 2 possibilities:

The first one, using regular expression, as you mention in your question. And I believe this is the best solution.
The second one, using the $where queries.

With $where queries you can specify expression like these

db.foo.find({"$where" : "this.x + this.y == 10"})
db.foo.find({"$where" : "function() { return this.x + this.y == 10; }"})

and so you can use the JavaScript .indexOf() on string fields.

answered Apr 14, 2012 at 8:51

dash1e

7,8251 gold badge32 silver badges39 bronze badges

Comments

user799188 · Accepted Answer · 2012-04-15 09:46:18Z

0

Code snippet using the $regex clause (as mentioned by mikeycgto)

String searchString = "ab";
DBCollection coll = db.getCollection("yourCollection");
query.put("name", 
  new BasicDBObject("$regex", String.format(".*((?i)%s).*", searchString)) );
DBCursor cur = coll.find(query);
while (cur.hasNext()) {
  DBObject dbObj = cur.next();
  // your code to read the DBObject ..       
}

As long as you are not opening and closing the connection per method call, the query should be fast.

answered Apr 15, 2012 at 9:46

user799188

14.6k5 gold badges38 silver badges38 bronze badges

Collectives™ on Stack Overflow

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

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related