Database - Remove Everything After
If the column never has an underscore other than the one you want to remove, you can use SUBSTRING_INDEX().

update yourtable set yourcolumn = substring_index(yourcolumn,'_',1);