How to reference a collection name with "." in Mongo db?

Question

I have a mongo DB, in the mongo shell, when I run "show collections", it returns the collection with dot in the collection name like

a.1
a.2
a.3

How I refer it in command like

db.a.1.find()

the above returns SyntaxError: missing ; before statement

If you're going to answer your own question, you need to put more effort into explaining why the problem exists. You should expand your answer into *why* it works that way. — SomeKittens, Mar 04 '13 at 23:21

score 12 · Accepted Answer · answered Mar 04 '13 at 22:57

12

figure it out. wrapping it in [ ]. basic javascript knowledge.

db["a.1"].find()

answered Mar 04 '13 at 22:57

Russel Yang

1

Same thing will work if your collection name has special characters like space , hypen ,.. – Prem Sanil Jan 02 '20 at 11:19

1 Answers1