I would like to delete multiple rows in an mySQL table based on message "ids" I have in an array, @MESSAGE_IDS. The MESSAGE_ID array would have message id numbers (13, 14, 15, 19, 25, 44, etc...), each of which identify messages I would like to delete.
I would like to delete all of them with one Select and prepare statement, in "one fell swooop" if I can. My first reaction was to use a while loop like this:
while $i (@MESSAGE_IDS){
my $sth = $dbh->prepare("DELETE * FROM table
WHERE message_id = '$message_id'");
$sth->execute();
# and so on ...
}
But apparently calling prepare and execute over and over is not a good way of deleting multiple rows. Is there a better dbi function or function to accomplish what I want without calling prepare and execute in a loop?
Red------