Using a regex with text search in MongoDB

Question

I have created a text index on the num field in the collection. Now while passing the string to search from the text index, I need to use a regex which has to be passed as a string to the $search variable.

My current query works fine but it doesn't work when I add a regex to it.

Current Query:

db.collection.find({$text:{$search:"1234 6789"}},{'id':1})

I need to add a regex/like query to the $search to make it something like

db.collection.find({$text:{$search:"/1234/ /6789/"}},{'id':1})

where I get all the values from the database that contain a pattern like "1234" OR "6789".

I did try the query but it gives me a $search needs a String error:

db.collection.find({$text:{$search:/1234/}},{'id':1})

If you want regex then text search will be useless to you (for multiple reasons), you want to delove to normal querying. — Sammaye
– Sammaye, Commented May 25, 2014 at 13:20
@Sammaye That being rectified, can I search multiple regex terms as a string.Basically I am trying to pass this query term from the client side itself to reduce the string building process on the server. — Rohit Minni
– Rohit Minni, Commented May 25, 2014 at 13:37

Rohit Minni · Accepted Answer · 2014-05-25 14:48:00Z

5

To achieve this you should use the $regex MongoDB operator:

// Without options
db.collection.find({num: /1234|5678/i});

// Separate options property
db.collection.find({num: {$regex: /1234|5678/, $options: 'i'}});

To add multiple terms in the regex, use the | operator

$regex docs and examples

Edit:

For querying records using an array of values the $in operator can be used:

$in docs and examples

edited May 25, 2014 at 14:48

Rohit Minni

2501 gold badge3 silver badges8 bronze badges

answered May 25, 2014 at 14:19

Catalin MUNTEANU

5,6442 gold badges37 silver badges43 bronze badges

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

3 Comments

Rohit Minni Over a year ago

How can I add multiple regex terms to this. Like /1234/ OR /5678/

Rohit Minni Over a year ago

okay, So I did figure it out. Thanks. /1234|5678/ would be it!

Catalin MUNTEANU Over a year ago

If the keywords contain only numbers and letters that will work.

Collectives™ on Stack Overflow

Using a regex with text search in MongoDB

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related