my @set = ($c .. $d);
my $sql =
  'SELECT type FROM dog WHERE number IN ( ?'.(',?' x $#set).') ';
my $sth = $db->prepare($sql)
   $sth->execute(@set);