Remove String from column based on character
SELECT SUBSTRING_INDEX(name, '(', 1) FROM test;

UPDATE test
    SET name = TRIM(SUBSTRING_INDEX(name, '(', 1));


(assuming you want to get rid of the space, too)