Skip to main content

How to get collection object when use where in collection

I am trying to add where in collection but it return

Varien_Db_Select Object

instead of return collection object.

$collection = Mage::getModel('orderoutofuk/orderitem')->getCollection()->getSelect()->where('main_table.send_payment_request_date >= DATE(NOW()) - INTERVAL 7 DAY ');

and I want specific column value in array instead of looping through each object.