By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mDemo(id integer(11), value varchar(256));
INSERT INTO mDemo VALUES(1, 'Value1(12) Value2(45) Value3(35) Value4(37) Value5(17)');
UPDATE mDemo SET value = REGEXP_REPLACE(value, '[(][0-9]{2,}[)]', '')
Rows matched: 1 Changed: 1 Warnings: 0
SELECT * FROM mDemo;
| id | value |
|---|---|
| 1 | Value1 Value2 Value3 Value4 Value5 |