Forums / Setting Up Categories, Products, Attributes / Batch updating title with phyMyAdmin?

Batch updating title with phyMyAdmin?

Views: 462

Results 1 to 1 of 1
18 Aug 2011, 11:08 PM
#1
randyrand avatar

randyrand

New Zenner

Join Date:
Mar 2010
Posts:
23
Plugin Contributions:
0

Batch updating title with phyMyAdmin?

Hi all,

I neglected to take note of the setting that would display my product titles when I started months ago, and now I've got thousands of pages with no keyword-rich titles and Goolge hates them. :blink:

I've been going through them all and manually changing the metatag status to include the title and my site tagline on each page, but I realized it would be a heck of a lot faster if I could do it through phpMyAdmin.

I used this post as a guide and think I have the correct syntax, but I'd like to check to make sure before I do it - it's the first time I've ever done a site-wide batch update in phpMyAdmin.

UPDATE products SET metatags_products_name_status = 1 WHERE metatags_products_name_status = 0;

UPDATE products SET metatags_title_tagline_status = 1 WHERE metatags_title_tagline_status = 0;

Is that correct?