Perl and MySQL

I have a MySQL table that is used to store comments on my blog. I just
found out it's filled with spam. The table itself is 2 GB big, with
more than half a million spam backlinks. I haven't found much material
on how to interact between Perl and MySQL. What I'd like to do is do a
simple Perl script that opens the DB table, goes through all rows and
deletes all those which contain "<a href". I'll have to do that during
the night, not to disrupt the server. How could I do that?
Thanks,

.

Relevant Pages

  • Re: postfix cant send and receive mails (SOLVED) - resend
    ... have an empty mydestinations and add all the domains for which mail ... To run following commands on mysql to create further new domain:- ... weather 450 is the right response or not: If you always don't want to ... You can do the same for SPAM, ...
    (Debian-User)
  • Calling Perl module from C coredumps on connection to MySQL database
    ... I've written a C program that calls a perl script. ... and the perl script needs to connect to the MySQL database. ... The MySql version is 5.0.22-Debian_0ubuntu6.06.2. ... fprintf (stderr, "BM: MySQL Error - Can't init MySQL ...
    (perl.dbi.users)
  • Re: spam removal
    ... great idee to add a spam feature. ... I work with sendmail, no mysql db behind. ... >> I'd be grateful for some tips on how to get dspam up. ...
    (freebsd-questions)
  • Re: MySQL time
    ... Yes I know that I can benchmark the perl script using but I am ... Or that time shown by mysql client is not returned by MySQL server but by ... > it is exactly that you need (elapsed time to execute a query? ...
    (perl.beginners)
  • Re: Is there free SQL or Oracle servers for FC4?
    ... > I need t write perl script to work with one of the subject-servers. ... > will work with SQL? ... though the DBD module that is appropriate for the target database. ... use MySQL or PostgreSQL but there are DBD modules for about everything. ...
    (Fedora)