UPDATE `accounts_cstm` ca, recovery re SET ca.accounttypetwo_c = ‘Project Owner’ WHERE re.ID = ca.id_c;
SELECT * FROM `accounts_cstm` WHERE `accounttypetwo_c` LIKE ‘Proj%’
UPDATE `accounts_cstm` ca, recovery re SET ca.accounttypetwo_c = ‘Project Owner’ WHERE re.ID = ca.id_c;
SELECT * FROM `accounts_cstm` WHERE `accounttypetwo_c` LIKE ‘Proj%’