86Stang Posted May 29, 2008 Share Posted May 29, 2008 Hi All, I've got a client with a database where there are records with the same email address. They want me to remove any records that have a duplicate email address but I must leave one of those records intact. In other words, I'm wanting to take the table from this: [email protected] [email protected] [email protected] [email protected] [email protected] to: [email protected] [email protected] Anyone want to give up some points of wisdom on this? Link to comment https://forums.phpfreaks.com/topic/107882-removing-duplicate-records/ Share on other sites More sharing options...
86Stang Posted May 30, 2008 Author Share Posted May 30, 2008 I know you're all dying to answer my question but PLEASE form an orderly line to the left so nobody gets hurt. Link to comment https://forums.phpfreaks.com/topic/107882-removing-duplicate-records/#findComment-553575 Share on other sites More sharing options...
fenway Posted May 30, 2008 Share Posted May 30, 2008 You could add a UNIQUE idex. Link to comment https://forums.phpfreaks.com/topic/107882-removing-duplicate-records/#findComment-553797 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.