Thanks for Justin Cook for doing all the leg work on this one.
All you have to do is create a new table from the old one, which filters out the duplicate entries
1 2 3 | CREATE TABLE new_table AS SELECT * FROM old_table WHERE 1 GROUP BY [colum_to_remove_duplicates_from]; |
so as an example
1 2 | CREATE TABLE news_new AS SELECT * FROM news WHERE 1 GROUP BY [title]; <a href="http://www.concept47.com/austin_web_developer_blog/developers/getting-rid-of-duplicate-entries-in-your-mysql-database/#more-113" class="more-link">Continue reading <span class="meta-nav">→</span></a> |