How to replace part of text in Sql table with query?

Question

MySQL

In the product table there is a description field in which you need to delete all "(MMLDS / RU)" models in brackets are always different. Delete along with parentheses.
Tried like this, but nothing comes out. If you explicitly specify the replacement string, then it works.

UPDATE product SET  `description` = REPLACE(  `description` , like'%(%)%',  '' )

Thank you.

Answer 1

UPDATE `product`
  SET `description` = CONCAT(SUBSTRING_INDEX(`description`, '(', 1), SUBSTRING_INDEX(`description`, ')', -1)) 
  WHERE `description` LIKE '%(%)%'

Answer 2

UPDATE product SET  `description` = 
CONCAT(  SUBSTR(`description`, 1, INSRT(`description`, '(')-1), 
         SUBSTR(`description`, INSRT(`description`,')')+1) )