Multiple fields to sort a magento collection

Question

Here is target sql query: ...... order by field1 asc, price_index.min_price desc

And here is my code

$productCollection->getCollection()
         ->setOrder('field1', 'asc')
         ->setOrder('price', 'desc')

However in my result price always is first ordering field. can anyone help me, Please ? Thank you so much

Answer 1

$collection->getSelect()
    ->order('field1 asc');

or sort by multiple:

 $collection->getSelect()
    ->order(array('field1 asc', 'price desc'));