MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE oc_product_description  (
`name` varchar(50) 
                                   ) ;
INSERT INTO oc_product_description values
('some random text &quot;'),
('some  text &quot;'),
('some  text');
select * from oc_product_description;

name

some random text &quot;

some  text &quot;

some  text

UPDATE oc_product_description SET name = REPLACE(name, '&quot;', ''); 
select * from oc_product_description;

name

some random text

some  text

some  text