?
Solved

SQL Injection with Random conent -how to clean?

Posted on 2008-10-17
2
Medium Priority
?
567 Views
Last Modified: 2012-05-05
Hi there - we have recently had what seems to be an SQL injection attack - but this time the code inserted into DB fields appears to be random links to other sites. When I say random, I mean that each row within the table has had different content appended to the original content. I've attached an example of what has been appended below. The main part of it is within <SPAN STYLE='display:none'> </SPAN>  followed by a comment within  <!--   -->.   The format of the injection appears consistent throughout although the content differs between the start/end tags inserted. I hope this makes sense! I have a cleaner script for previous attacks - but the difference here is that content to be removed varies throughout each row. Is there a way to UPDATE by removing from <SPAN STYLE='display:none'>  UNTIL   -->

I hope this makes sense. And thanks in advance.

Pete

<SPAN STYLE='display:none'>
<P>Choroid chary dusky clubman extortionate enforcement lien backwall enlisted pretensioning trey toxoid eliminable sequence. <I>Iodide</I>.
<A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=262264330&#38;img=154958">buy fioricet online</A> uninterpreted <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=915218182&#38;deptID=3167&#38;ptype=3">cheap adipex</A> <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0&#38;generic-propecia">generic propecia</A>
 <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=397991413&#38;img=154958">cheap xanax</A>
 <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24524">viagra</A> <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=712056575&#38;deptID=3167&#38;ptype=3">hydrocodone</A>
 <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=154">lisinopril</A> <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=924624159&#38;deptID=3167&#38;ptype=3&#38;amoxicillin">amoxicillin</A> <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1751&#38;buy-vicodin">buy vicodin</A> <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=320">xenical</A>
 gardinol <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24612">ambien online</A>
 <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=627724958&#38;deptID=3167&#38;ptype=3">proscar</A>
 <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=711770683&#38;deptID=3167&#38;ptype=3">buy hoodia</A> <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=337">buy xanax</A> <B>pericranial</B> <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=316">purchase valium</A> <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=765913125&#38;deptID=3167&#38;ptype=3">tretinoin</A>
 <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=997441058&#38;img=154958">buy adipex</A>
 vernal <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=396616396&#38;deptID=3167&#38;ptype=3">amoxicillin</A>
 <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=135">vardenafil</A> <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=145348258&#38;img=154958&#38;fluconazole">fluconazole</A>
 <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0">levofloxacin</A> <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0">levofloxacin</A>
 <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1737">augmentin</A> <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=148">buy phentermine</A>
 <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24538&#38;esomeprazole">esomeprazole</A>
 affrayer <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1742">generic zoloft</A>
 <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24609">tretinoin</A> <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0&#38;tadalafil">tadalafil</A> <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=105859818&#38;deptID=3167&#38;ptype=3&#38;diflucan">diflucan</A>
 homy <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1748&#38;furosemide">furosemide</A>
 <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0&#38;bextra">bextra</A> <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0">levofloxacin</A> <B>gauche</B> outvote <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=729815673&#38;deptID=3167&#38;ptype=3">lorazepam</A>
 <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=847262221&#38;deptID=3167&#38;ptype=3&#38;purchase-xanax">purchase xanax</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24540">cheap tramadol online</A> <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0">levofloxacin</A> dystectics <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24587">order carisoprodol</A> <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=693853055&#38;deptID=3167&#38;ptype=3">buy ambien</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24595">cheap cialis</A>
 <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=343&#38;cheap-adipex">cheap adipex</A> <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=546354827&#38;img=154958&#38;generic-norvasc">generic norvasc</A>
 <I>turbofan</I> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24521&#38;amlodipine">amlodipine</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24518">esgic</A> gules <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=143&#38;purchase-phentermine">purchase phentermine</A> invitation <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=784694970&#38;img=154958">adipex online</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24580">fioricet</A>
 <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=157">cheap tramadol online</A>
 <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=526520010&#38;img=154958">nexium online</A>
 <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24599">order cialis online</A> <I>balaclava</I> <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=117972570&#38;img=154958">ciprofloxacin</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24596">diazepam</A> <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1723&#38;propecia">propecia</A>
 <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=323&#38;buy-amoxicillin">buy amoxicillin</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24526">buy levitra</A>
 <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24574&#38;cozaar">cozaar</A>
 terpinene astrogram <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=886823253&#38;deptID=3167&#38;ptype=3">retin-a</A> <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=319&#38;generic-zyrtec">generic zyrtec</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24525">xenical online</A>
 <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24575">alendronate</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24582">allegra</A>
 extrapolating <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=634118839&#38;img=154958">singulair</A> psychokinetic gearmotor <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0">levofloxacin</A> <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0&#38;order-xanax">order xanax</A>
 <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24513&#38;buy-nexium">buy nexium</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24591">diazepam online</A>
 <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=145">buy valium online</A> <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=129">levitra</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24597">generic ambien</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24512">buspirone</A>
 <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=330">generic levitra</A> <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1747">generic finasteride</A>
 <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1731&#38;plavix">plavix</A>
 <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1720">simvastatin</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24552">danazol</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24581&#38;zovirax">zovirax</A> <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0&#38;generic-prozac">generic prozac</A>
 <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=290168160&#38;deptID=3167&#38;ptype=3">cheap propecia</A> <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=344218241&#38;img=154958">tizanidine</A>
 <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=635962465&#38;deptID=3167&#38;ptype=3">keflex</A>
 <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=340381952&#38;img=154958">generic plavix</A> <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=937817593&#38;deptID=3167&#38;ptype=3">order tramadol</A> <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=101702022&#38;deptID=3167&#38;ptype=3&#38;losec">losec</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24532">viagra online</A> <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=161">motrin</A> <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0">levofloxacin</A>
 <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24588&#38;darvon">darvon</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24531">generic zyrtec</A>
 <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=313&#38;order-tramadol">order tramadol</A>
 <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24584">order adipex</A>
 lactozone <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24578">generic nexium</A> <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0">levofloxacin</A>
 <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1733">buy soma online</A>
 <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=146">fexofenadine</A> <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1746">prevacid</A> heterophyasis <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=231005485&#38;img=154958">sonata</A> <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0">levofloxacin</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24544&#38;generic-prevacid">generic prevacid</A>
 <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1725">vardenafil</A>
 <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0">levofloxacin</A>
 <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=348">cheap propecia</A>
 <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1736">ciprofloxacin</A>
 mastoidotomy alehoof <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24549&#38;order-xenical">order xenical</A>
 practices <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24611">cetirizine</A> <I>expansive</I> hussar <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=151&#38;buy-tramadol">buy tramadol</A>
 <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24529">cheap valium</A> <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1724">norco</A>
 <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=133">cialis</A> <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=389284042&#38;deptID=3167&#38;ptype=3">cetirizine</A>
 <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=141">kenalog</A>
 <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0&#38;cheap-propecia">cheap propecia</A> <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=266259426&#38;img=154958&#38;buy-viagra-online">buy viagra online</A>
 <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=160&#38;fioricet">fioricet</A> buddhist <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1718">metformin</A> <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=680790754&#38;deptID=3167&#38;ptype=3">naproxen</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24585">lunesta</A> <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=125">ultram</A> <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=577877177&#38;deptID=3167&#38;ptype=3&#38;generic-zoloft">generic zoloft</A> perplexity <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1744&#38;diflucan">diflucan</A> <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=327">generic zocor</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24535">allegra</A>
 <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=698896844&#38;img=154958">prednisone</A> <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=863425378&#38;deptID=3167&#38;ptype=3">cheap viagra online</A> milliangstrom <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0&#38;buy-prozac">buy prozac</A> <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0">levofloxacin</A> <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=338">cheap levitra</A>
 <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1749">cheap levitra</A> <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1734">nexium</A>
 <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1717&#38;generic-propecia">generic propecia</A>
 <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1716">buy tramadol</A> <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0">levofloxacin</A> revaluation <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24539">imovane</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24527">adipex online</A> undecagon maturemeter <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=163&#38;cheap-valium">cheap valium</A> <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=592046528&#38;deptID=3167&#38;ptype=3&#38;xenical-online">xenical online</A>
 <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0">levofloxacin</A> <I>reave</I> frenotron <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24563">prozac online</A> <B>own</B> <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=188700032&#38;img=154958&#38;bupropion">bupropion</A>
 <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=126">losartan</A>
 <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=440860365&#38;deptID=3167&#38;ptype=3&#38;reductil">reductil</A>
 <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1735">generic celexa</A> aquagel <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24583&#38;ambien">ambien</A> <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=349">purchase tramadol</A>
 <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24586">buspar</A>
 <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24610">singulair</A> <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=312">prilosec</A> <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=563926227&#38;img=154958">prevacid</A> triazane rustbound <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24592">generic paxil</A> <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=568988994&#38;img=154958">kenalog</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24546">buy hydrocodone</A> <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=131">order phentermine</A> <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=321">buy levitra online</A>
 anchusa pleading dimply <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=347">carisoprodol online</A> <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=143180322&#38;deptID=3167&#38;ptype=3">amlodipine</A>
 <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0&#38;meridia">meridia</A>
 <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=195025593&#38;deptID=3167&#38;ptype=3">buy hoodia</A> <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=180119140&#38;deptID=3167&#38;ptype=3">finasteride</A>
 <I>fleam</I> <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=876634037&#38;deptID=3167&#38;ptype=3">xanax online</A> <B>cinemactress</B> <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=124&#38;generic-effexor">generic effexor</A> <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=158">orlistat</A>
 <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=315&#38;nasacort">nasacort</A> <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=493273791&#38;img=154958&#38;soma">soma</A> <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=886093024&#38;img=154958&#38;buy-levitra-online">buy levitra online</A>
 <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24553">cheap alprazolam</A> heaving <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0">levofloxacin</A>
 <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=132675088&#38;deptID=3167&#38;ptype=3&#38;hoodia">hoodia</A> <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1756">cheap cialis online</A> citronellic <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=134">generic nexium</A> <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=342">simvastatin</A>
 <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=406451790&#38;img=154958&#38;tadalafil">tadalafil</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24551&#38;nasacort">nasacort</A> wineglass <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=372915243&#38;deptID=3167&#38;ptype=3&#38;viagra">viagra</A> <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=324">effexor</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24550">generic propecia</A> <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0&#38;generic-ultram">generic ultram</A>
 shifter <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24598&#38;triamcinolone">triamcinolone</A> <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0">levofloxacin</A>
 <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24523">buy alprazolam</A> <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=350&#38;hydrocodone">hydrocodone</A> <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=144&#38;adipex">adipex</A> <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=201656501&#38;img=154958&#38;buy-xanax">buy xanax</A> <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=159&#38;cheap-phentermine-online">cheap phentermine online</A>
 <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0&#38;tramadol">tramadol</A> <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1745&#38;viagra">viagra</A>
 <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24603&#38;buy-carisoprodol">buy carisoprodol</A> <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=331">lorazepam</A>
 <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=293228276&#38;img=154958">retin</A> <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0">levofloxacin</A> <A HREF="http://enews.coloradomtn.edu/index.cfm?method=c.ProfileDetail&#38;ID=333">carisoprodol</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24589">buy tramadol online</A> angiofibromyosarcoma <A HREF="http://www.internet-stationers.co.uk/Shop/istationers_shop/index.asp?productID=881252778&#38;deptID=3167&#38;ptype=3">cheap propecia</A> <A HREF="http://www.medicalreservecorps.gov/detail.asp?State=58&#38;id=1727">buy hoodia</A>
 <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24514">cheap alprazolam</A>
 <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=947175947&#38;img=154958">buy ultram online</A> <A HREF="http://www.propertynetworkspain.com/property_details_printout.cfm?ID=24606">buy hoodia</A> unsaturation <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0">levofloxacin</A>
 <A HREF="http://www.powerhousemuseum.com/collection/database/theme_view.php?nirn=996979216&#38;img=154958&#38;vardenafil">vardenafil</A> <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0">levofloxacin</A> <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=149&#38;buy-amoxicillin">buy amoxicillin</A> <A HREF="http://www.websocials.com/getwork/comments.asp?blogID=142&#38;buy-tramadol-online">buy tramadol online</A> cusped <A HREF="http://www.comedysoapbox.com/comedianstemplate.cfm?RequestTimeout=5000&#38;comedianID=0">levofloxacin</A>
Cover nonpresentment diethylamide. Baculus intraperitoneal toxicomania anaglyph amniote codeine organometallic!<BR>
Domic voltaite odorization nincompoop. Chlorothiophenol briefcase overfilling oversubtle gelatination triplicating meroquinene expension mudguard leaflet? Bisacodyl strays enclave,.<BR>
</SPAN>
<!--
Clayey dragnet luminesce plethorically daynrumb nostalgia alloimmunity chemosensitivity elongate hyperthermal.
-->

Open in new window

0
Comment
Question by:pkates
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 37

Accepted Solution

by:
momi_sabag earned 2000 total points
ID: 22740242
sure you can !

update my_table
set my_column =
  substring(my_column,1, charindex('<SPAN STYLE=''display:none''>', my_column) +   -- this will get all your data up to the injected data
  substring(my_column, charindex('-->', my_column,  charindex('<SPAN STYLE=''display:none''>', my_column)), len(my_column)) -- this will get the rest of the data
where charindex('<SPAN STYLE=''display:none''>', my_column) > 0
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question