mysql mass delete

dwidb · #1 (**permalink**) 12-29-10, 01:39

Hi friend,
My site got hack attack. this hacker put unpleasant sentence in all my articles. I have huge number of articles, I just wondering is it possible to delete unpleasant sentence in all my articles from database? so i can delete it in one go..

r937 · #2 (**permalink**) 12-29-10, 05:54

yes it's possible

Code:

UPDATE sometable 
   SET somecolumn = REPLACE(somecolumn,'bad sentence','')

drhalens · #3 (**permalink**) 01-08-11, 10:28

You can also do it without php by just using phpmyadmin's search function. B

But before making any changes I recommend to find the hole in your security to prevent future attacks.