http://qs1969.pair.com?node_id=319088


in reply to deleting from a mysql database

UNTESTED

my @array = qw(Anna Maria Carmen); my @phldrs = ('?') x @array; local $" = ','; my $sql = qq/DELETE FROM tnt WHERE Name NOT IN (@phldrs)/; my $sth = $dbh->prepare($sql); $sth->execute(@array); $sth->finish;
--
3dan