Hi all, I'm looking for some help with an SQL query I want to make. I know as much about SQL as I do about golf so I don't really know where to start I've been neglecting my directory a little and as a result there are about 350 pending spam submissions. I'd like to run a query which will drop all of the things (fields?) in the table PLD_LINK which have their STATUS set as 1 (1 means pending, 2 means approved, I think). Could anybody help me please? Cheers, Dan
DELETE from pld_link WHERE status=1 You use the word "I think" in your description which is never a good thing when talking about deleting things, so make a backup beforehand, and verify that status=1 means what you think it does!