MySQL Forums
Forum List  »  Newbie

DELETE * FROM `font_comment` WHERE `status`=`pending`
Posted by: Doug Peters
Date: November 21, 2018 04:59PM

Hello. Excuse me, please, idiot here.

I am trying to figure out how to delete the spam out of my comments. For some reason, the Russians post a lot of crap no one ever sees.

I need to run a command (SQL tab of phpadmin) to delete any entry from the table "font_comment" that has a "status" of "pending".

That will delete over 6000 entries/(rows?).

I know this is wrong:

DELETE * FROM `font_comment` WHERE `status`=`pending`

I can delete them from the CMS, but only one at a time.

I don't apologize for looking foolish, I rarely use MySQL or phpAdmin other than backup, import and export. But knowing this will allow me to avoid a great deal of work and headache.

Thanks in advance for your help. I did look in the manual, but all the quotes seem to be different, and there are so many uneeded arguments in the syntax, I just need to qualify the delete and do it.

Database is backed up, no worries there.

Options: ReplyQuote


Subject
Written By
Posted
DELETE * FROM `font_comment` WHERE `status`=`pending`
November 21, 2018 04:59PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.