How to run custom MySQL Query in Magento?

$db = Mage::getSingleton(‘core/resource’)->getConnection(‘core_write’);

$result = $db->query(‘Select * from Tablename’);