Hi all. Let's say that quizzes have many tags, through taggings.
I'm doing a search on quizzes, including various other associations, and
passing in various conditions, such as "quizzes.name like '%english%'"
or "quizzes.subject = 'Language'".
If i'm given a parameter :tag => "banana" then i want to order my
results so that the quizzes are ordered by their tags, but with the ones
with the 'banana' tag pushed up to the top of the results. I'm doing a
paginated search (with will_paginate) so i don't want to get all of the
results with a regular find(:all) and then re-order them - i want to do
it in the sql
Can i do this by passing something to the 'order' option? Something
along these pseudo-code lines (the order option is not valid but
hopefully gets my requirement across):
@quizzes = Quiz.paginate(:all, :conditions => <conditions>, :order =>
"tags.name = 'banana' or tags.name", :page => params[:page], :per_page
grateful for any advice - thanks, max