Update Accounts (email and phone)

SugarCRM

 

SugarCRM is a cloud CRM from the SugarCRM software company, that includes sales force automation, marketing campaigns, customer support, collaboration, reporting, etc. features.

UPDATE account's email and phone data

Query Text

UPDATE Accounts SET email1 = 'Union.Bank@ub.com', phone_office = '(088) 12-56-987' 
    WHERE name like 'Union%'
  

Open Query