my $select = "SELECT value FROM table WHERE distinguishing_value = ?";
my $sth = $dbh->prepare($select) or die $dbh->errstr();
$sth->execute() or die $dbh->errstr();
print $sth->rows;