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. :] Quote Link to comment 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\' Quote Link to comment 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! 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.