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?