Here's my problem, I would like to use phpmyadmin to perform an innerjoin using like. Here's the beginning of the code:
UPDATE homeowners10 INNER JOIN homeowners ON homeowners.Last_Name = homeowners10.last AND Homeowners.Address = homeowners10.address SET homeowners10.email = homeowners.email The problem is that in ontable the address is spelled last part of the address is spelled out (Court) in the other it is abbreviates (Ct).
Can this be done with phpmyadmin? If not can you tell me how to do it programmatcially with php?