How to make an "Update" query in Magento 1.9? I have no Idea how to do it. I added "filtered" column in catalog_product_entity table.
I have the product I.D and here's my Query.
$productId = '9'; $data = array('filtered'=>0); $model = Mage::getModel('catalog/product')->load($productId)->addData($data); $model->setId($productId)->save();
And this is the query what i want to achieved.
"UPDATE catalog_product_entity SET filtered = 1 WHERE entity_id = 9".
Note: The column "filtered" is added manually using "ALTER TABLE" in catalog_product_entity.