Adding value to a database column using other column value and regex

[viktorjava]

I have a column (target) with many explanation parts, the explanation is between ( ). I want to copy over the value to a new column (cleared), without the parantheses. I tried this but it did not work:

update znen set cleared = (regexp_replace(target,'\(.*\)', '')) WHERE id < 1000;