phpmyadmin bulk search replace

[buildingblocks]

Hi

I need to do a bulk search and replace of a string of text which exists in hundreds of product descriptions.
This is what I plan on using in phpmyadmin. Could someone tell me if I have this formatted correctly?

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

Also if I drop the zen_ prefix can I run this directly from admin?

[mc12345678]

Hi

I need to do a bulk search and replace of a string of text which exists in hundreds of product descriptions.
This is what I plan on using in phpmyadmin. Could someone tell me if I have this formatted correctly?

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

Also if I drop the zen_ prefix can I run this directly from admin?

Yes on all accounts. Might see a slight improvement if added

WHERE your_field LIKE '%link-to-replace.html%'

Also, the link portion to replace and be replaced with may contain escape characters that need to be considered. Review of one of your subject descriptions should identify that.

[buildingblocks]

thank you :-)

should it now look like this?


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%');

[mc12345678]

thank you :-)

should it now look like this?


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%');

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%';

[buildingblocks]

at the moment I am only anticipating needing to replace several links



oldlink.html

to

newlink.html

if it happens that there are any dashes - used in the link does the - need to be escaped? \-

I am aware that ' needs to be escaped as in can\'t

[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

[buildingblocks]

It works perfectly. Thanks for your help.