sqlite> create table foo (foo int, bar int);
sqlite> insert into foo (foo, bar) values (1,1);
sqlite> insert into foo (foo, bar) values (1,2);
sqlite> insert into foo (foo, bar) values (1,3);

##</code><code>##

sqlite> select * from foo where foo = 1 and bar in (1,2,3);
1|1
1|2
1|3

##</code><code>##

my $sth = 
$dbh->prepare('select * from foo where foo = $1 and bar in ($2)');
$sth->execute(1, [1,2,3]);