my $sth = $dbh->prepare("select employee_number from employees where employee_number = '$employee_number' for update"); $sth->execute; my $userID = ($sth->fetchrow)[0]; if ($userID) { print "This employee is already in there \n"; }