Luke Cowell wrote in post #969470:
> This filters out rows where name is null and orders by name in SQL:
> Category.where("name NOT NULL").order("name ASC")
>
> I'm not sure how to get mysql to downcase the column, but I'm pretty
> sure there's a way.I believe the standard SQL function for that is lower(). Check the docs. > > Luke Best, -- Marnen Laibow-Koser http://www.marnen.org [email protected] Sent from my iPhone -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
