How do I query MongoDB with `like`?

Question

I want to return users whose names starts with `E` in MongoDB. Something like `SELECT * FROM users  WHERE name LIKE 'E%'` in SQL. But I'm not sure how to do it MongoDB.

Anusha · Accepted Answer

MongoDB uses regular expressions for pattern matching. You can query like below to get users whose names start with `E`

```
db.users.find({name: /^E/})
```

If you want to make a case in-sensitive query then you can use the option `i` as shown below:

```
db.users.find({name: /^E/i})
```

How do I query MongoDB with `like`?

1 Answer