How to query MongoDB with “like”?

Question

I want to query something with SQL's like 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 write it like this:

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

Are you interested in learning SQL from scratch! Have a look at this interesting video on SQL provided by Intellipaat:

or, like this code:

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

Basically, you are looking for something that includes “m” somewhere (i.e. ‘%’ operator of SQL is equivalent to Regexp’s’.*’), not something that contains “m” anchored to the beginning of string.