how can clean table from the database

2 Feb 2014, 9:38 AM

Totally Zenned

in my products have this

Meta Tag Keywords:
Meta Tag Description:

where is the table can clean all ? i have about 500 products with Meta Tag Keywords:, Meta Tag Description:

i want clean this table so this table empty for all products .

thank you for understand .

4 Feb 2014, 5:23 AM

Zen Follower

Re: how can clean table from the database

If I understand your English correctly, you need to clear the meta tag keywords and descriptions.

I'm not very good at writing php code, but if anyone out there could writeup a code somewhat like this one:

UPDATE products SET products_tax_class_id=1;

This code works for setting the tax class on all the products to 1, not sure if a modified code would work for setting the meta tags to null.