Case Insensitive Where Statement Using SQL In Rails
Posted by Weston Ganger
If you want to make your where statement case insensitive on a column you can use the SQL function
I needed this for some import / export scripts I was running.
val = 'rails' Post.where('lower(title) LIKE ?', val)
Related External Links: