phpsqlprogrammer Posted December 19, 2003 Share Posted December 19, 2003 How do I mass delete entries with a certain value in a particular column? Hi, thanks for answering in advance. How do I mass delete all entries that has a value, say 123.123.com under the column \"remotehost\" in a table? Any SQL query that fits my description?? You see, this is a counter script and I am trying to remove all the counts that belong to me. Thanks. :] Link to comment https://forums.phpfreaks.com/topic/1529-how-do-i-mass-delete-entries-with-a-certain-value-in-a/ Share on other sites More sharing options...
shivabharat Posted December 19, 2003 Share Posted December 19, 2003 This code will delete the entries which belongs to \"123.123.com\" delete from <table-name> where remotehost=\'123.123.com\' Link to comment https://forums.phpfreaks.com/topic/1529-how-do-i-mass-delete-entries-with-a-certain-value-in-a/#findComment-5027 Share on other sites More sharing options...
phpsqlprogrammer Posted December 19, 2003 Author Share Posted December 19, 2003 Thank you so much! Now, I do not have to manually delete them one by one! Thanks, shivabharat! Link to comment https://forums.phpfreaks.com/topic/1529-how-do-i-mass-delete-entries-with-a-certain-value-in-a/#findComment-5028 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.