Well I was having some bigger problems with my huge database.

So I thought of removing all the duplicate entries and keep one instance of it in the database.

Now I tried this for one week and then also I had nothing on my hand. It is not that I don't know PHP or MySQL.

But everyway I try it was getting so resource intensive that it was never able to acomplish the thing.

So I wrote one nice query for it. Which can remove all the duplicates and keep just one instance of that record in the table.

I have attached the file with this post.

Thanks. Hoping this might come in help to others.

Attached File(s)

  query.txt (Size: 58 bytes / Downloads: 5)