UPDATE tblemailtemplates_static
SET name = REPLACE(name, 'Staff', 'Team Member')
WHERE name like '%staff%';

UPDATE tblemailtemplates
SET name = REPLACE(name, 'Staff', 'Team Member')
WHERE name like '%staff%';

UPDATE tblemailtemplates_static
SET name = REPLACE(name, 'Customer', 'Client')
WHERE name like '%customer%';

UPDATE tblemailtemplates_static
SET name = REPLACE(name, 'customer', 'Client')
WHERE name like '%customer%';

UPDATE tblemailtemplates
SET name = REPLACE(name, 'Customer', 'Client')
WHERE name like '%customer%'  ; 

UPDATE tblemailtemplates
SET name = REPLACE(name, 'customer', 'Client')
WHERE name like '%customer%' ;