How to make a query case insensitive?

Question

Ruby on Rails

news = News.arel_table
query_string = "%#{params[:text]}%"
@news = News.where(news[:title].matches(query_string))

The passed values ​​"Title" and "Title" are different. If the first is found, then the second is not. How to fix it?

Answer 1

For Postgres, you can do something like this:

query_string = UnicodeUtils.upcase(params[:text], :ru)
@news = News.where('UPPER(news.title) LIKE ?', "%#{query_string}%")

And don't forget to add the corresponding index

Answer 2

i did this user = User.where("lower(email) = ?", params[:email].downcase).first