MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table some_table ( some_column varchar(255) );
insert into some_table values ('Value1(12) Value2(45) Value3(35) Value4(37) Value5(17)');
update some_table
set some_column = regexp_replace(some_column, '\\([^)]*\\)', '')

Rows matched: 1  Changed: 1  Warnings: 0

select * from some_table;

some_column

Value1 Value2 Value3 Value4 Value5