Mongodb driver regex find

Question

    String pattern = ".*" + "a? I'm" + ".*";
    FindIterable<Document> document = collection.find(regex("mypost", pattern, "i")).sort(new Document("mypost", -1));

I want a regex that contains the terms "a? I'm". For some reason this pattern picks up collections with mypost as "? I'm" when I want only "a? I'm".

What is wrong with it?

Ivan Vasiljevic · Accepted Answer · 2019-11-11 02:22:34Z

1

The problem with your regex is that ? has special meaning

? - Once or none

So your regex is basically saying - before " I'm" you can have a or not.

Your regex in fact should look like this:

String pattern = ".*" + "a\\? I'm" + ".*";

By adding \\ you should specify that you want to use ? as a character.

answered Nov 11, 2019 at 2:22

Ivan Vasiljevic

5,7282 gold badges33 silver badges36 bronze badges

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

4 Comments

bobby Over a year ago

Okay that does it fix but now my issue is that I cant manually change every symbol with 2 `\`'s since that part of the text isn't always fixed if that makes sense. Is there a command like exactText(string)

FailingCoder Over a year ago

\\ Won't show as a character, why don't you experiment?

bobby Over a year ago

@FailingCoder I mean if I were send a request with a string such as "abc? I'm" RESTfully I wont know the position of every symbol

FailingCoder Over a year ago

Experiment then.

Collectives™ on Stack Overflow

Mongodb driver regex find

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related