Delete Duplicate Email Records That Are Attached To One Account But Can Be Found In Multiple Accounts
Posted on 2015-01-16
I have a table, consumer_mgmt. It collects consumer information from various forms. These forms are available through different pages that are part of a business package.
A business can offer these signups to gather names and emails from consumers for various types of specials they may offer. So a consumer my be in the consumer_mgmt table 5, 10, 15 times for that particular business.
But, that consumer may be in the consumer_mgmt table multiple times for a different business. So multiple times for multiple businesses.
I need to remove duplicates for each business account so the consumer is only the consumer_mgmt only once for each business.
There are approximately 15,000 rows currently in the consumer_mgmt table.