finding duplicates entries — ruby — codestacker

you are in: codestacker → codes [RSS] → finding duplicates entries

finding duplicates entries

having example in rails. from: http://blog.grayproductions.net/articles/five_activerecord_tips

show/hide lines

   1  duplicates = User.find( :all,
   2    :select     => "email, COUNT(email) AS duplicate_count",
   3    :conditions => "email IS NOT NULL AND email != ''",
   4    :group      => "email HAVING duplicate_count > 1"
   5  )

duplicates = User.find( :all,
  :select     => "email, COUNT(email) AS duplicate_count",
  :conditions => "email IS NOT NULL AND email != ''",
  :group      => "email HAVING duplicate_count > 1"
)

created by leozera — 18 July 2009 — get a short url — tags: activerecord rails sql — embed

Comments