my @SQLs = map { "INSERT INTO $_ (address_1, address_2, county, city, zip, description, status, bedroom) VALUES (?, ?, ?, ?, ?, ?, ?, ?)" } qw( property property2 ); my @sths = map {$dbh->prepare($_)} @SQLs;