How to query documents with "like" statement in Mongoose

In Mongoose, you can use the $regex operator to perform a search query in MongoDB, similar to SQL LIKE statement.

MongoDB uses regular expressions for pattern matching that is more powerful than SQL LIKE statement. Regular expressions allow you to create any search pattern that you can imagine.

Here is an example that finds documents containing a specific string:

const mongoose = require('mongoose')

const User = mongoose.model('User', { name: String })

const users = await User.find({ name: { $regex: /john/i } })

Note that the i in the above query indicates case in-sensitive match. You can also pass a RegExp object instead of $regex operator:

const users = await User.find({ name: new RegExp('john', 'i') })

To match a field that starts with a specific string, you can use the following query:

const users = await User.find({ name: { $regex: /^john/i } })

Similarly, to find documents that end with a specific string, use the following query:

const users = await User.find({ name: { $regex: /john$/i } })

✌️ Like this article? Follow me on Twitter and LinkedIn. You can also subscribe to RSS Feed.

You might also like...

Digital Ocean

The simplest cloud platform for developers & teams. Start with a $200 free credit.

Buy me a coffee ☕

If you enjoy reading my articles and want to help me out paying bills, please consider buying me a coffee ($5) or two ($10). I will be highly grateful to you ✌️

Enter the number of coffees below:

✨ Learn to build modern web applications using JavaScript and Spring Boot

I started this blog as a place to share everything I have learned in the last decade. I write about modern JavaScript, Node.js, Spring Boot, core Java, RESTful APIs, and all things web development.

The newsletter is sent every week and includes early access to clear, concise, and easy-to-follow tutorials, and other stuff I think you'd enjoy! No spam ever, unsubscribe at any time.