need to remove some stuff from description

-- url of the page with the problem -- : www.ifixmachines.com
-- HikaShop version -- : 4.4.0
-- Joomla version -- : 3.9.24
-- PHP version -- : 7.4.14
-- Browser(s) name and version -- : chrome
-- Error-message(debug-mod must be tuned on) -- : none

I have a site from 2009 that I imported into hikashop I'd like to use mass action to remove a line of code from the description if is found.

this is the code that is in about 1/2 of my product descrptions. <hr id="system-readmore" />

Can you help me code the proper query string and action to remove it.

Hi,

You want to have an action "update the values" on the product_description column with the type "operation" and the value:

It removes the complete description if the <hr id="system-readmore" /> is found in the description.

here is a link to the mass action page of the operation.

nimb.ws/HyYhkN

Hi,

My bad, I put the parameters in the wrong order:
www.w3resource.com/mysql/string-function...replace-function.php
it should be:
REPLACE(product.product_description,'<hr id="system-readmore" />', '')