How to check if string length is >0 in mongodb?

Question

I am firing mgo from GoLang on MongoDb to find records which have trimmed string length greater than zero, I tried below but neither is working, please help.

findQuery["shopname"] = bson.M{"$where": "len > 0"}
findQuery["shopname"] = bson.M{"$where": "shopname.len > 0"}
findQuery["shopname"] = bson.M{"$where": "this.shopname.len > 0"}
findQuery["shopname"] = bson.M{"$regex": ".*.*"}

Possible duplicate of [String field value length in mongoDB](https://stackoverflow.com/questions/29577713/string-field-value-length-in-mongodb) — Jonathan Hall, Apr 06 '18 at 07:49

score 2 · Accepted Answer · answered Apr 06 '18 at 09:33

2

If you are looking just for non-empty values, try this:

bson.M{"$exists": true, "$ne": ""}

answered Apr 06 '18 at 09:33

Kevin Sandow

4,003
1
20
33

Thanks a lot, you are best! – Nikhil Joshi Apr 07 '18 at 09:10

score 0 · Answer 2 · answered Apr 08 '18 at 17:38

0

Another way or another approach would be to check if 0th element of array exists or not.

"arr.0" : bson.M{"$exists": true}

answered Apr 08 '18 at 17:38

Saransh

629
2
8
14

How to check if string length is >0 in mongodb?

2 Answers2