Webmastersite.net
Register Log In

Mass Delete Comments with SQL
Need sql query to mass delete all comments for lin

Comments on Mass Delete Comments with SQL

osirs
Member

Usergroup: Customer
Joined: Mar 01, 2003
Location: San Diego

Total Topics: 12
Total Comments: 31
osirs
Posted Aug 26, 2006 - 4:43 PM:

Please help by providing me with a sql query I can run to delete all comments for my linkid 164. I have 31,882 comments I need to delete. Alternatively is there a way to mass delete comments for a single linkid with WSN links? I am using phpMyAdmin but I am not sure how to write the query to perform this task.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7867
Paul
Posted Aug 27, 2006 - 12:50 PM:

DELETE FROM wsnlinks_comments WHERE linkid=164;
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.