my $sth=$dbh->prepare("SELECT * FROM my_table WHERE primary_key = ?");

$sth->execute(4);
    
my @record = $sth->fetchrow();