SQL query for site-wide word replacement?

I've managed to improperly capitalize a word on my site on multiple products and descriptions, as well.

Is there an easy via SQL to search for the word "Foo" and make it "foo", site-wide?

Sure there is ...
Just make sure you back up your data base first incase you mess up ..:smile:

http://www.zen-cart.com/showthread.php?124425-SQL-command-to-find-and-replace-a-word-in-the-products-description

thanksl, although my word is also in the title of the product, will this replace that as well? If so, i'm assuming this is adequate?

UPDATE products_description SET products_description = REPLACE(products_description, "Foo'", "foo");

bi11i:

thanksl, although my word is also in the title of the product, will this replace that as well? If so, i'm assuming this is adequate?

UPDATE products_description SET products_description = REPLACE(products_description, "Foo'", "foo");

I see the mistake that I made here, got a little confused about the extra apostrophe in the example "2x3'". That worked great, except for product names - is there any easy to fix this, as well?

You should be able to do essentially the same thing using the product name field. You will have to look up the correct table and field name(s). Note that there might be multiple tables to alter... not certain whether the product name is repeated, or purely linked by reference to the product id.

Look carefully at all "products_" tables and their fields.

gjh42:

You should be able to do essentially the same thing using the product name field. You will have to look up the correct table and field name(s). Note that there might be multiple tables to alter... not certain whether the product name is repeated, or purely linked by reference to the product id.

Look carefully at all "products_" tables and their fields.afraid i'm not knowledgeable enough to be doing this kind of thing. I may resort to manually making the edits but the description suggestion was quite helpful and will save me some time.

thanks so much!

If you really don't like playing around with phpmyadmin or sql commands, you could simply download your complete database as a file, put it into notepad, and simply do a word replace as you would with any text document, save the file and then re-upload your database.

Make a back up first though.