typomaniac - 4:14 am on Jul 3, 2012 (gmt 0)
Got it fixed.. Kept searching and eventually found an answer. Not sure why the syntax I have been using didn't work in this case but I found one:
my $sql = qq`DELETE FROM table WHERE column='$_'`;
my $sth = $dbh->prepare($sql) or die "Cannot prepare: " . $dbh->errstr()
$sth->execute() or die "Cannot execute: " . $sth->errstr();
Still have a question however and that is in regards to the backticks. I have seen somewhere that backticks should be avoided. Any comments on that.