Select column from Mongodb in golang using mgo

Question

As I know, we can use

> db['twitter-3'].find({}, {"text": 1})

to select all texts in collection.

How can we use mgo to find specific field in golang? I tried

var result []string
err = conn.Find(bson.M{}, bson.M{"text", 1}).All(&result)

But it is not correct.

user5728991 · Accepted Answer · 2015-06-29 13:25:30Z

26

Use the query Select method to specify the fields to return:

var result []struct{ Text string `bson:"text"` }
err := c.Find(nil).Select(bson.M{"text": 1}).All(&result)
if err != nil {
    // handle error
}
for _, v := range result {
     fmt.Println(v.Text)
}

In this example, I declared an anonymous type with the one selected field. It's OK to use a type with all document fields.

answered Jun 29, 2015 at 13:25

user5728991

Sign up to request clarification or add additional context in comments.

3 Comments

Wyatt Over a year ago

In the structure, what does bson:"text" stand for? Is there any reference that I can check to have a better understand for this?

Amol Over a year ago

Thanks! How does one select multiple columns? Just adding Select(bson.M{"text": 1, "anotherColumn":1}) does not work.

muthukumar selvaraj Over a year ago

why it returns intype map[][] ` not as json

edrzmr · Accepted Answer · 2018-02-23 17:16:43Z

2

to select multiple fields:

var result []struct{
    Text string `bson:"text"`
    Otherfield string `bson:"otherfield"`
}

err := c.Find(nil).Select(bson.M{"text": 1, "otherfield": 1}).All(&result)
if err != nil {
   // handle error
}
for _, v := range result {
    fmt.Println(v.Text)
}

answered Feb 23, 2018 at 17:16

edrzmr

514 bronze badges

Comments

Jyotsna Gupta · Accepted Answer · 2019-05-20 02:23:46Z

0

var result interface{}
err = c.Find(nil).Select(bson.M{"text": 1}).All(&result)

answered May 20, 2019 at 2:23

Jyotsna Gupta

212 bronze badges

Collectives™ on Stack Overflow

Select column from Mongodb in golang using mgo

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related