http://www.perlmonks.org?node_id=1031698


in reply to Using multiple values in a SQL "in" statement

Assuming you wanted the contents of @id in place of the question mark:

use strict; use warnings; my @id=(1,2,3,4,5); my $sql = "SELECT name FROM table where id in (".join( ",", @id).")"; print "$sql\n";