I want to update the FullDescription field based on a value in the Name field :
SELECT Name
FROM Nop_Product
WHERE (Name LIKE '%(MEN)%') :
ACQUA DI PARMA by Acqua di Parma (MEN) COLOGNE SPRAY 3.4 OZ
FullDescription field :
<strong>ACQUA DI PARMA by Acqua di Parma</strong> - <span style='font-size:15px;'>Genuine Brand Name Perfume</span><p style='font-size:18px;color:black;padding-top:10px;padding-bottom:10px;'>COLOGNE SPRAY 3.4 OZ</p>Gender : MEN<br /><br />Brand : ACQUA DI PARMA<br /><br />Designer : Acqua di Parma<br /><br />Fragrance : rosemary, citrus, lavender
I want to replace the string : 'Genuine Brand Name Perfume' in FullDescription
with 'Genuine Brand Name Fragrance'
WHERE the string '(MEN)' is in the field 'Name'
UPDATE [Nop_Product]
SET FullDescription =
WHERE
What's the best way to do this? thanks