CODEWITHSUNDEEP
mongodbgomgo
Wyatt
Wyatt

Reputation: 1455

Select column from Mongodb in golang using mgo

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.

Upvotes: 16

Views: 19263

Answers (3)

Jyotsna Gupta
Jyotsna Gupta

Reputation: 21

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

Upvotes: 0

drrzmr
drrzmr

Reputation: 51

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)
}

Upvotes: 2

Thundercat
Thundercat

Reputation: 120941

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.

Upvotes: 26

Related Questions