my $sth=$dbh->prepare("Update table1 set password='$newpassword' where binary table1.emailaddress = binary table2.emailaddress and table2.uniqueid ='$unique_id'"); $sth->execute();