If you want to make your where statement case insensitive on a column you can use the SQL function lower

I needed this for some import / export scripts I was running.

val = 'rails'
Post.where('lower(title) LIKE ?', val)

Related External Links:

• Stack Overflow - case-insensitive-search-in-rails-model