mongodb regex parameter

Question

Refer to the code below:

{$or: [
        {titleLong: { $regex: regExp } },
        {catalog: { $regex: regExp } },
        {catalogNbr: { $regex: regExp } }
      ]}

I am trying to find the documents whose fields match a certain regex expression. For example, there's this document.

{course: {titleLong: "Introduction to analysis of algorithms"},
         {catalog: "cs3333"},
         {catalogNbr: "3333"}}

and when the user types "intro algo" or "3333" or "cs3333" the document should be returned. I tried /(intro|algo)/gi but it doesn't work becaue it returns all documents that either have intro or algo. Also, the g options doesn't seem to work. I also found the following regex:

(?=.*\bintro\b)(?=.*\balgo\b).+

But this only finds documents that have words that are exactly like intro and misses introduction.

Remove the first \b to find entries with words starting with the values: (?=.*\bintro)(?=.*\balgo).+ — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Apr 7, 2015 at 14:30

Avinash Raj · Accepted Answer · 2015-04-07 14:30:55Z

2

Remove the word boundaries present inside the lookahead assertion so that it would do a partial match.

(?=.*intro)(?=.*algo).+

OR

(?=.*intro).*algo.*

And don't forget to turn on the case insensitive modifier i

Include the pattern to match "3333" or "cs3333" also.

(?=.*intro).*algo.*|^(?:cs)?3333$

answered Apr 7, 2015 at 14:30

Avinash Raj

175k32 gold badges247 silver badges289 bronze badges

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

Comments

Wiktor Stribiżew · Accepted Answer · 2015-04-07 14:39:46Z

0

You can use PCRE when you define $regex. You can return all entries starting with specific words, and use inline options like (?i) (case insensitive search). Here is an example:

 {titleLong: { { $regex: '(?i).*\bintro.*' } }

or entris containing "intro" in any position in the string:

 {titleLong: { { $regex: '(?i).*intro.*' } }

answered Apr 7, 2015 at 14:39

Wiktor Stribiżew

631k41 gold badges502 silver badges632 bronze badges

Collectives™ on Stack Overflow

mongodb regex parameter

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related