Mongodb regex query

Question

Inside Mongodb I would like to search with regex. For example I would like to make a query to returns all of these:

"ab-cd/ef" 
"ab/cd.ef" 
"abcdef"

I have created that query

db.getCollection('collection').find({detail:{$regex:"ab.*.cd.*.ef"}}

but the problem is that it cannot find "abcdef"

JohnnyHK · Accepted Answer · 2015-08-17 17:34:09Z

1

Remove the trailing .s so that it's just:

db.getCollection('collection').find({detail: {$regex: "ab.*cd.*ef"}}

With the trailing .s it's requiring at least one char between each group.

answered Aug 17, 2015 at 17:34

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

1 Answer 1