Are mongodb ids unique ?

How do I query mongodb with “like”?


SQL Server like used “%” operator but in mongodb used “.*” operator.

In the below example, I am looking for something that contains “ak” as string.

Query 1:   db.customers.find({"name": /.*ak.*/})
Query 2:  db.customers.find({"name": /ak/})


We can also use regex, the example look like below.

db.customers.find({ "name": { $regex: /ak/i } })
OR
db.customers.find({"name": /^ak/})
OR
db.customers.find({'name': {'$regex': 'ak'}})




ANIL SINGH

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Buy Books Online at Best Prices

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.