How to use regex in mongodb query?

Member

by denis , in category: PHP Databases , 9 months ago

How to use regex in mongodb query?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by adan , 3 months ago

@denis 

To use regular expressions in a MongoDB query, you can use the $regex operator in the query document.


Here is an example of how to use the $regex operator in a MongoDB query:

1
db.collection.find({ field: { $regex: /pattern/ } })


This will find all documents in the collection where the value of the field field matches the regular expression pattern.


You can also use the $options operator to specify options for the regular expression, such as case insensitivity. For example:

1
db.collection.find({ field: { $regex: /pattern/i } })


This will find all documents in the collection where the value of the field field matches the regular expression pattern, ignoring case.


You can also use the $regex operator in other MongoDB operators, such as $match in the pipeline of an aggregate function.

1
2
3
4
5
6
7
db.collection.aggregate([
   {
      $match: {
         field: { $regex: /pattern/ }
      }
   }
])


This will find all documents in the collection where the value of the field field matches the regular expression pattern and return them as part of the aggregation pipeline.