sql - Delete this virus by searching for matching strings -
i have screenshot of virus:
<div style="display:none">women cheat <a href="http://blog.armanda.com/page/women-who-cheat-with-married-men.aspx">go</a> online</div><div style="display:none">link <a href="http://by-expression.com/page/my-girlfriend-started-to-communicate-with-ex">online</a> how cheat husband</div><div style="display:none">dating married men <a href="http://by-expression.com/page/my-girlfriend-started-to-communicate-with-ex">click</a> why people cheat in relationships</div><div style="display:none">why men have affairs <a href="http://by-expression.com/page/my-girlfriend-started-to-communicate-with-ex">women cheated</a> when husband cheats</div><div style="display:none">reasons why husband cheat <a href="http://blog.smartofficecloud.com/page/reasons-married-men-cheat">why wife cheat</a> dream husband cheated on me</div><div style="display:none">how tell if wife has cheated <a href="http://www.cfrtu.org/events.asp">married men cheat</a> boyfriend cheated on me mom</div><div style="display:none">my girlfriend cheated on me <a href="http://www.chimneyfans.com/contents.aspx?page=fans">link</a> women cheat on husbands</div>
how can find strings start <div style="display:none">
, ends </div>
, delete it?
wouldn't:
--to check select * [your_table] [your_column] '<div style="display:none">%' --to delete delete [your_table] [your_column] '<div style="display:none">%'
work ?
edit
it sounds need use regular expression in clause:
Comments
Post a Comment