phpmyadmin bulk search replace

[buildingblocks]

Close but no:

update zen_products_description set products_description = replace(products_description,'link-to-replace.html','change-to-this-link.html') WHERE products_description LIKE '%link-to-replace.html%';

ok I see what I missed....the closing parentheses was out of place

thank you