How to write query with LIKE in MongoDB?

Question

The document looks like:

{
    "_id" : ObjectId("5c11389782c3c3751def6a68"),
    "\"dname\"" : "\"W6PJBu7wC0Demyl86pd8Um5NHk3ukqsdtVA6                       \""
}

I've searched a lot and found that I can write it as: /. For example, I need to get all document where dname starts with c, for this I do:

db.getCollection('flat').find({"\"dname\"" : "\"c/"})

Also I've tried this:

db.getCollection('flat').find({"\"dname\"" : "/^\"c/"})

but it does not work. What I do wrong?

score 2 · Accepted Answer · answered Dec 12 '18 at 21:39

2

You need to use regexes

For example, to find records with dname starting with c: db.getCollection('flat').find({"\"dname\"" : /^\"c/})

answered Dec 12 '18 at 21:39

ack_inc

1 Answers1