Oh ok, that is cool, thanks.
On Sun, Dec 19, 2010 at 21:09, Luke Cowell <[email protected]> wrote:
> Hi Chris, you could try something like this:
> categories = Category.select("*, LOWER(name) as lower_name")
>
> The calculated column 'lower_name' would now be available as a accessor on
> each result. eg. categories.first.lower_name
>
> Luke
>
> On 2010-12-19, at 6:42 PM, Chris Habgood wrote:
>
> It is, how do I implement it with the Rails 3 finders?
>
> On Sun, Dec 19, 2010 at 20:35, Marnen Laibow-Koser
> <[email protected]>wrote:
>
>> 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]<rubyonrails-talk%[email protected]>
>> .
>> For more options, visit this group at
>> http://groups.google.com/group/rubyonrails-talk?hl=en.
>>
>>
>
> --
> 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.
>
>
> --
> 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]<rubyonrails-talk%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/rubyonrails-talk?hl=en.
>
--
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.
