Empty brackets appearing when using where

Question

I m trying to display all Guides where title contains the word  attack   I do so like so   def attack    guides   Guide where title   attack   end   Quick question - How do I make it non case-sensitive and restrictive  It can contain any spelling of the word  attack  like  AtTaCK   and it can have more words  As long as Attack is in it somehow   Then  to print them out in the view  I do this    lt    guides each do  guide    gt     lt    guide title   gt   lt   end   gt

User · Accepted Answer

A good bet is to utilize Rails  Arel SQL manager  which explicitly supports case-insensitive ActiveRecord queries   t   Guide arel table Guide where t  title  matches   attack      Here s an interesting blog post regarding the portability of case-insensitive queries using Arel  It s worth a read to understand the implications of utilizing Arel across databases

User · Answer

Stuarts  answer is correct  but if you are not sure if you are saving the titles in lowercase  you can also make a case insensitive search  There are a lot of answered questions in Stack Overflow with more data on this   Example 1  Example 2

User · Answer

You can use the lower function   Guide where  lower title   attack      As a comment  Work on your question  The title isn t terribly informative  and you drop a big chunk of code at the end that is irrelevant to your question

[ruby-on-rails] Empty brackets '[]' appearing when using .where

Examples related to ruby-on-rails

Examples related to ruby

Examples related to activerecord

Examples related to view

Examples related to controller