How to use delete request and condition in magento

Question

I need to execute the following query in magento

DELETE FROM `table_name` WHERE `column1` = '" . $value1. "' and `column2`='" . $value2. "'"

How can I create this in purple form, for example,

Mage::getModel('module/model')->setId($id)->delete();

Thanks in advance....

Answer 1

I do not test it, but I hope that it works for you.

$collection = Mage::getModel('model/model')->getCollection()
    ->addFieldToFilter('column1',array('eq'=> $value1))
    ->addFieldToFilter('column2',array('eq' => $value2))
;

foreach($collection as $coll)
{
    Mage::getModel('module/model')->load($coll->getId())->delete();
}