Query Syntax in mongodb for sql "like" - i am using java

Question

basically this is my question: How to query MongoDB with "like"?

but i guess all the answers in here are applicable when you are using mongodb shell command line, so what is the equivalent for db.users.find({"name": /.*m.*/}) when we are using java.

here is how i am trying to do

  DBCollection coll = MongoDBUtil.getDB().getCollection("post_details");      
    BasicDBObject query = new BasicDBObject();      
    query.put("price", new BasicDBObject("$gt", 5).append("$lt", 8));

    /*what should i write instead of this line*/ 
            query.put("title", "/.*m.*/");

    DBCursor cur = coll.find(query);

Sean Reilly · Accepted Answer · 2012-05-09 13:56:09Z

14

For this issue you should use a regex as in this example:

BasicDBObject query = new BasicDBObject();
Pattern regex = Pattern.compile("the title you are looking for"); // should be m in your case
query.put("title", regex);

edited May 9, 2012 at 13:56

Sean Reilly

21.9k4 gold badges51 silver badges63 bronze badges

answered May 9, 2012 at 13:52

sebastian

2,5075 gold badges35 silver badges37 bronze badges

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

7 Comments

MoienGK Over a year ago

thnx. u mean i should write : Pattern regex = Pattern.compile("/.*m.*/"); if i want to find titles which contains "m" ?

sebastian Over a year ago

@dave you can simply write Pattern regex = Pattern.compile("m");

Sean Reilly Over a year ago

+1 — note that MongoDB will "do the right thing" and perform an efficient search with a regex if possible (basically when the regex has a wildcard only at the end)

MoienGK Over a year ago

using pattern makes it so easy! can i use pattern instead of something like this maybe : query.put("price", new BasicDBObject("$gt", 5).append("$lt", 8)); i am getting greedy for more comfort :D

Sean Reilly Over a year ago

@dave: Probably not :-(. Even if the query you describe did work, MongoDB wouldn't be able to use an index to resolve it anymore, so it would probably make the query much slower. IMO it's best to restrict regex use to places that you would use a LIKE clause in a SQL query.

|

hestellezg · Accepted Answer · 2017-06-23 21:12:04Z

0

Taking the above example as reference, but using the Filters class:

Pattern regex = Pattern.compile("title you look for");
Bson filter = Filters.eq("nombre", regex));

answered Jun 23, 2017 at 21:12

hestellezg

3,7913 gold badges36 silver badges38 bronze badges

Collectives™ on Stack Overflow

Query Syntax in mongodb for sql "like" - i am using java

2 Answers 2

7 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related