$elements = join('","',@MESSAGE_IDS); $elements = '"'.$elements.'"'; my $sth = $dbh->prepare("DELETE * FROM table WHERE message_id in ($elements)"); $sth->execute();