SQL help

[tizer]

OK - I'm a dumbass - I set up a blog a few months ago with an auto poster and a rssMagician feed... only thing is I choose to rewrite the title - which as it turns out is what the auto poster uses to check for duplicates

So I have around 8000 posts on this blog, but only around 300 are unique.

I've got this SQL code to show me the unique records

SELECT DISTINCT post_content
FROM wp_posts
LIMIT 300;

But how do I get these unique records to replace the 8000 duplicate posts already have?

[Omar]

Well.. only that code does not help anyone too much. I think you should ask the maker of the autoposter that you use, they know better how their program work (and why even posted duplicates if it shouldn't)

[tizer]

OK - I fixed by making the post_content unique:

ALTER IGNORE TABLE wp_posts ADD UNIQUE INDEX indexname (post_content(50));

The reason it posted duplicates was because it checked the title for duplicates - so - which I was rewriting with rssMagician - not a problem, I just wanted to clean up an old blog