Here's an example I worked out. It doesn't require PHP, only direct mySQL commands you can feed into phpMyAdmin:
-- create a test table to demonstrate the solution
CREATE TABLE addresses (
fname VARCHAR(32),
lname VARCHAR(32),
email VARCHAR(32)
);
-- populate the table with a few duplicate...