title: method that Searches over specific columns in a table
body: <p>I need to create a method to search over a specific table <code>tournaments</code>, the method should search through the following columns :
  - name
  - address
  - starts_on
  - ends_on
  - city
  - postcode</p>
  
  <p>I am unsure how to do that, so far I have written a class method in my tournament model that looks like that :</p>
  
  <pre><code> def self.search(term)
      Tournament.where('name ILIKE ? OR starts_on ILIKE ? OR ends_on ILIKE ?' , "%#{term}%")
    end
  </code></pre>
  
  <p>How can I and what is the best way to do this ?</p>