How to log SQL query of the collection=?iso-8859-1?Q?=3F_=96_magento.stackexchange.com?=

How to log SQL query of the collection? – magento.stackexchange.com

I want to log the SQL query for a custom collection. I tried the following
code. But did not work. Any suggestions will be appreciated.
Mage::log($collection->getSelect(),null,'test.log',true);