[SOLVED] Removing Duplicate Database Entries

[papaface]

Hello,

 

Hope you can help me guys.

 

I am wanting to delete duplicate entries in my database.

 

At the moment I have something like this:

 

username | password | email address | status

test1 | password1 | [email protected] | 0

test1 | password1 | [email protected] | 0

test1 | password1 | [email protected] | 1

 

How can I remove the ones with the duplicate usernames but keep the one that has a status of "1"?

 

Any help would be appreciated!

 

Thanks

[laPistola]

use drop in phpmyadmin.

 

instead of always using INSERT to add data to a DB when there is a change you could just simply use UPDATE to change the status when its needed

 

ie

UPDATE users SET status = '1' WHERE username = 'test1'

[Mchl]

use drop in phpmyadmin.

 

DROP is command to drop (i.e. delete) whole tables.

 

papaface: if all the entries you wish to remove have status = 0 (or more precise, if you want to remove all entries with status = 0) use this:

DELETE FROM `table` WHERE `status` = 0;

[papaface]

use drop in phpmyadmin.

 

DROP is command to drop (i.e. delete) whole tables.

 

papaface: if all the entries you wish to remove have status = 0 (or more precise, if you want to remove all entries with status = 0) use this:

DELETE FROM `table` WHERE `status` = 0;

Thanks lol

I never thought of doing it that way