I need to delete many records.. URGENTLY.. need HELP

Hello all,

I was converting my old phpBB2 forum to the new phpBB3 forum.. but I found many users (more than 1000 users) that are duplicated and need to be deleted..
So I have the ID's of these users and need to delete them and I have no experience in MySQL..

So is there any easy way to delete mass numbers of users if I provided the ID's of this users ?

 

Hi,

Do you have phpmyadmin?

 

Yes I have

 

Click on SQL tab to enter a mysql command

DELETE FROM `table_name`WHERE user = user1 OR user = user2 OR user = ...

 

Yes it worked..

Thanks alot

I was deleting ID by ID in the past.. now it is much faster

 

Hello,
Maybe for the future, here there is an article about how to resolve your problem

http://www.databasejournal.com/features/mysql/article.php/2201621

Best,
Jakomo

 

Very useful article Jakomo.. green rep added

 

Thank you very much for good article Jakomo.