CODEWITHSUNDEEP
javaregexmongodb
Spiff
Spiff

Reputation: 2286

MongoDB find with regex behaves differently from Java

Regex find with MongoDB 2.4.6 is not behaving the same way as the Java Pattern class does. Can anyone explain why?

Inserting data in MongoDB:

db.Project.insert({ "_id" : "e0b57d9e-744c-471e-ae95-22a389d2988d", "name" : "Project.20131106101344433" });

Finding all Projects:

db.Project.find()

{
    "_id" : "e0b57d9e-744c-471e-ae95-22a389d2988d",
    "name" : "Project.20131106101344433"
}

Finding all Projects whose name is "t":

db.Project.find({"name" : /t/})

{
    "_id" : "e0b57d9e-744c-471e-ae95-22a389d2988d",
    "name" : "Project.20131106101344433"
}

Checking that sole Project name does not match regex "t":

@Test
public void regex() {
    assertTrue(!Pattern.matches("t", "Project.20131106101344433"));
}

As you see, the regex db.Project.find returns a Project whose name is not "t", but does contain "t". What am I missing?

Thanks!

Upvotes: 0

Views: 176

Answers (1)

Salvador Dali
Salvador Dali

Reputation: 222751

In this case db.Project.find({"name" : /t/}) you are not looking for a document whose name is t, you are looking for every document whose name contains t. You can read about PECL here and test what are you doing here.

To find exact match you have to do {"name" : 't'}

Upvotes: 2

Related Questions