dpziir0079 2014-10-29 09:48
浏览 112
已采纳

如何从mongodb获取唯一记录?

I have a collection named 'myplace'. It has the following fields: place_name, latitude, longitude, city, country.

I want all the cities that start with the letter "A". I tried the following:

type Place struct{
    City string `bson: "City"`
}

For retrieving the result from the db:

var city_name []Place
err = coll.Find(bson.M{"city": bson.M{"$regex":"^a", "$options":"si"}}).All(&city_name)

It's getting all the results. The problem is that some of the 'myplace' documents have the same city, so it's returning duplicate city names.

Let's say I have 5 myplaces, 3 with the city name "Baton Rouge" and remaining having "Trivandrum, Kochi". When I try to get the city starting with "B", it's returning "Baton Rouge" 3 times.

How can I ensure each city_name is unique?

Thanks in advance

  • 写回答

2条回答 默认 最新

  • dou2347 2014-10-29 10:19
    关注

    You can use the Distinct method, in the shell it will look like :

    db.foo.distinct( "city",  { "city" : { "$regex" : /^A/i    } }  );
    

    In Go:

     var result []string 
    
     err = c.Find( bson.M{"city": bson.M{"$regex":"^a","$options":"si"}}  ).Distinct("city", &result) 
    
     if err != nil {
            log.Fatal(err) 
     }
    
     fmt.Println( result )
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 银河麒麟不支持vant等前端框架怎么办?
  • ¥15 vue3的子组件在父页面调用不显示不生效问题
  • ¥15 cadence PEX
  • ¥15 phython创建了文件 显示在项目下面,但运行不了,运行时还是运行main文件,并且说main文件不允许并行运行
  • ¥20 C++哈希表的设计构造哈希表
  • ¥15 FutureWarning:不推荐使用空或全 NA 条目的 DataFrame 串联行为。怎么改呢?
  • ¥15 Chatgpt突然无法正常显示数学公式,如何解决?
  • ¥15 一个用华为模拟器做的实验。
  • ¥28 opencv Cuda C++编译
  • ¥15 插入sim卡4g模组反复断连