UPDATE m_product

SET em_mg_longdescription = regexp_replace(em_mg_longdescription,'------------',chr(13))

WHERE
em_mg_manufacturer = 1000637
AND value = 'IMI-YW356A01'

 

 

Some additional replace scripts

 

UPDATE m_product

SET em_mg_longdescription = regexp_replace(em_mg_longdescription,'</li>',chr(10))

WHERE
em_mg_manufacturer = 1000637

 

UPDATE m_product

SET em_mg_longdescription = replace(em_mg_longdescription,'<li>','')

WHERE
em_mg_manufacturer = 1000637

 

UPDATE m_product

SET em_mg_longdescription = replace(em_mg_longdescription,'<ul>','')

WHERE
em_mg_manufacturer = 1000637

 

UPDATE m_product

SET em_mg_longdescription = replace(em_mg_longdescription,'</ul>','')

WHERE
em_mg_manufacturer = 1000637