my $surname = 'Jones'; my $query= qq{SELECT name, surname FROM employees WHERE surname = $surname }; my $sth = $dbh->prepare($query); $sth->execute();