Note that you should probably use placeholders. It’s so easy with DBI that there’s rarely a reason not to.

my $stmt = "SELECT * FROM mytable WHERE id = ?";
my $sth = $dbh->prepare( $stmt );
$sth->execute( $myid );
my $results = $sth->fetchall_arrayref( {} );

# or

my $stmt = "SELECT * FROM mytable WHERE id = ?";
my $results = $dbh->selectall_arrayref( $stmt, undef, $myid );
[download]

Then you can also further optimise the first case by saying

my $sth = $dbh->prepare_cached( $stmt );
[download]

In that case, because the placeholder-adorned query is always the same, you might even end up preparing the statement only once during your entire runtime.

Makeshifts last the longest.