papaface Posted November 29, 2008 Share Posted November 29, 2008 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@somedomain.com | 0 test1 | password1 | email@somedomain.com | 0 test1 | password1 | email@somedomain.com | 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 Quote Link to comment Share on other sites More sharing options...
laPistola Posted November 29, 2008 Share Posted November 29, 2008 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' Quote Link to comment Share on other sites More sharing options...
Mchl Posted November 29, 2008 Share Posted November 29, 2008 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; Quote Link to comment Share on other sites More sharing options...
papaface Posted November 29, 2008 Author Share Posted November 29, 2008 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.