How to query MongoDB with “like”?

Question

I want to query something with SQL's like the query:

SELECT * FROM users WHERE name LIKE '%m%'

How to do I achieve the same in MongoDB? I can't find an operator for like in the documentation.

Answer 1

You can use something like as follows:

db.users.find({"name": /.*m.*/})

or, similar:

db.users.find({"name": /m/})

Answer 2

A regular expression is an important way of specifying a pattern for a complex search. The MongoDB $regex operator provides such a way to search a string after matching a specified pattern. mongodb uses regular expressions which are more powerful than "LIKE" in SQL. With regular expressions, you can create any pattern that you imagine.