Skip to content

Instantly share code, notes, and snippets.

@amaudy
Created May 24, 2012 15:40
Show Gist options
  • Save amaudy/2782286 to your computer and use it in GitHub Desktop.
Save amaudy/2782286 to your computer and use it in GitHub Desktop.
mongodb: Find dupplicate users and save to second collection
var previous_userid;
db.users.find( {"userid" : {$exists:true} }, {"userid" : 1} ).sort( { "userid" : 1} ).forEach( function(current) {
if(current.userid == previous_userid){
db.duplicates.update( {"_id" : current.userid}, { "$inc" : {count:1} }, true);
}
previous_userid = current.userid;
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment