Remove String from column based on character i have table : 

table : mytable


id  name
1   abcd ( dljdf
2   kjlkjkldjf ( ( ( ;dfld )


I want to remove string starting from character '('.

Result would look like 


id  name
1   abcd
2   kjlkjkldjf


I tried using Trim Function but it did not give me required result 

Any help plz.
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)