my $update="UPDATE `ml_message` SET `message_send`='N',`message_has_been_sent`='2010-12-06 10:59:20' WHERE `message_id`=3;"; $dbh->do($update) or die "problem while updating: $dbh->errstr \n";