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 |