Rails :order, can I order by 2 things at the same time, one before the other?

Question

so I want to do something like this:

, :order => "(products.name = 'Some Product' or products.name) desc", :order=>'distance'

has anyone done this before? I realize that I cant do it the way I have written, but hope it explains the order I want the orders to happen.

Answer 1

Yes, you can.

:order => "column1 ASC, column2 DESC"