sql - Delete this virus by searching for matching strings -


i have screenshot of virus:

enter image description here

<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:

msdn article

regexpal test regular expression

example of using regex in clause


Comments

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -