I needed a way to clean out a MySQL table of records with duplicate email addresses. To do this I used a simple SELECT query inside of an INSERT. INSERT INTO good_users(email) SELECT DISTINCT(email) FROM bad_users