Replace javascript in database with phpmysql

Question

Realated to this topic : Why do I receive an error in SQL when trying to find and replace javascript within a database

But didn't work for me. I have the same issue.

I tried:

SELECT
  `post_content`,
  REPLACE(`post_content`, '<script src=''https://hotopponents.site/site.js'' type=''text/javascript''></script>', ''), 
  COUNT(*)
FROM `db742664123`.`VUjlspmhposts` 
WHERE `post_content` LIKE '%<script src=''https://hotopponents.site/site.js'' type=''text/javascript''></script>%' COLLATE utf8_bin 
GROUP BY `post_content`
ORDER BY `post_content` ASC

Changed the db name and the table. But nothing happened, it returned 0.

Just want to erase these malicious code at once from the whole database.

MySQL returned zero result (zero line ). (Query took 0.0104 sec.) — snp_85
– snp_85, Commented Oct 9, 2018 at 17:17

sebap · Accepted Answer · 2018-10-20 17:35:56Z

2

This works:

UPDATE wp_posts SET post_content = REPLACE(post_content, '<script src=''https://hotopponents.site/site.js'' type=''text/javascript''></script>', '')

answered Oct 20, 2018 at 17:35

sebap

1,6915 gold badges26 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Replace javascript in database with phpmysql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related