Regex with OR in Java - mongoDB

Question

How can I create the following query:

Name LIKE "ABC" or "DFG" in java driver for mongoDB?

I know that for creating regex without "or" I do it in this way:

  BasicDBObject regexQuery = new BasicDBObject();
  regexQuery.put("name",
       new BasicDBObject("$regex", "ABC"));

enator · Accepted Answer · 2018-01-04 15:41:16Z

3

The normal | operator works on mongo.

This should do:

BasicDBObject regexQuery = new BasicDBObject();
regexQuery.put("name",
       new BasicDBObject("$regex", "ABC\\|DFG"));

If trying on mongo shell:

db.collection.find({name:/ABC|DFG/}).pretty()

answered Jan 3, 2018 at 13:25

enator

2,6093 gold badges31 silver badges48 bronze badges

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

1 Comment

one can also use Pattern.compile("ABC\\|DFG")