SQL搜索和替换

Question

Admittedly, I'm a noob when it comes to SQL commands. A hacker inserted a script tag at the end of every post and page on one of my WordPress sites, and I'm trying to do a find and replace in the 'wp_posts' table but I keep getting a #1064 error when I run a Simulate Query. Here's what I have:

UPDATE wp_posts SET post_content=REPLACE(post_content, '<script type="text/javascript" src="http://www.hcifx.com/troyengelhardt/index1261.php"></script>', '');

I get the error no matter what I put inside that first set of 'find' quotes, even if it's something as simple as 'hcifx' instead of the entire script tag shown. Any ideas where I'm going wrong?

Answer 1

It turns out the error is a known bug in PhpMyAdmin. The query was valid, but using the 'Simulate Query' function throws an erroneous error. I backed up my database and ran the query as written and it successfully stripped the offending code from all posts in the db table.