String comparisons with variable cases

How do you guys get around having to downcase both sides of a string
comparison when one of the string comes from the database.

I think if you put it as a condition on the sql, then the case is
ignored by MySQL.

How do you guys replicate this behavior in Ruby code like say after you
already get an AR object from the database?