Table of Contents
MongoDB is a NoSQL database that uses regular expressions (regex) to query and retrieve data. One way to query using regex in MongoDB is by using the “Like” operator. This allows you to search for patterns or partial matches within a field’s value. The “Like” operator uses the case-insensitive syntax “/pattern/” to match the specified pattern in the field’s value. This can be useful for searching for specific strings or characters within a larger string. By using “Like” regex in MongoDB, you can efficiently retrieve data that meets your search criteria and customize your queries to fit your specific needs.
MongoDB: Query with “Like” Regex
You can use the following methods to perform a query in MongoDB with “like” regex:
Method 1: Find Documents that Contain String
db.collection.find({name: {$regex : /string/i}})
Note that the i indicates a case-insensitive match.
Method 2: Find Documents that Start with String
db.collection.find({name: {$regex : /^string/i}})
Method 3: Find Documents that End with String
db.collection.find({name: {$regex : /string$/i}})
The following examples show how to use each method with a collection teams with the following documents:
db.teams.insertOne({team: "Mavs", position: "Guard", points: 31})db.teams.insertOne({team: "Spurs", position: "Guard", points: 22})db.teams.insertOne({team: "Rockets", position: "Center", points: 19})db.teams.insertOne({team: "Warriors", position: "Forward", points: 26})db.teams.insertOne({team: "Cavs", position: "Guard", points: 33})Example 1: Find Documents that Contain String
We can use the following code to find all documents that contain the string ‘avs’ in the team field:
db.teams.find({team: {$regex : /avs/i}})This query returns the following two documents:
{ _id: ObjectId("618050098ffcfe76d07b1da5"),
team: 'Mavs',
position: 'Guard',
points: 31 }
{ _id: ObjectId("618285361a42e92ac9ccd2c6"),
team: 'Cavs',
position: 'Guard',
points: 33 }Example 2: Find Documents that Start with String
We can use the following code to find all documents that start with the string ‘gua’ in the position field:
db.teams.find({position: {$regex : /^gua/i}})This query returns the following three documents:
{ _id: ObjectId("618050098ffcfe76d07b1da5"),
team: 'Mavs',
position: 'Guard',
points: 31 }
{ _id: ObjectId("6180504e8ffcfe76d07b1da7"),
team: 'Spurs',
position: 'Guard',
points: 22 }
{ _id: ObjectId("618285361a42e92ac9ccd2c6"),
team: 'Cavs',
position: 'Guard',
points: 33 }Example 3: Find Documents that End with String
We can use the following code to find all documents that end with the string ‘ward’ in the position field:
db.teams.find({position: {$regex : /ward$/i}})This query returns the following document:
{ _id: ObjectId("618050808ffcfe76d07b1dab"),
team: 'Warriors',
position: 'Forward',
points: 26 }Note: You can find the complete documentation for $regex .
Cite this article
stats writer (2024). How can I query using “Like” regex in MongoDB?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-query-using-like-regex-in-mongodb/
stats writer. "How can I query using “Like” regex in MongoDB?." PSYCHOLOGICAL SCALES, 2 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-query-using-like-regex-in-mongodb/.
stats writer. "How can I query using “Like” regex in MongoDB?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-query-using-like-regex-in-mongodb/.
stats writer (2024) 'How can I query using “Like” regex in MongoDB?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-query-using-like-regex-in-mongodb/.
[1] stats writer, "How can I query using “Like” regex in MongoDB?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How can I query using “Like” regex in MongoDB?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.