How to query mongodb with "like" ?

Question

I'm using mongodb 1.4.

I want query something as SQL's like.

For an example in SQL:

select * from users where name like '%m%'

How to do the same in mongodb? I can't find a operator for like in the document of http://www.mongodb.org/display/DOCS/Advanced+Queries

Answer 1

You would use regex for that in mongo.

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

Answer 2

That would have to be:

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

or, simpler,

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

You're looking for something that contains "m" somewhere (SQL's '%' operator is equivalent to regexps' '.*'), not something that has "m" anchored to the beginning of the string.