title: Postgres - WHERE clause on whether values contain a certain string
body: <p>If I want to retrieve all entries such that the column <code>foo</code> value contains a string <code>'bar'</code>, is there a simple way to do this in SQL, or Postgresql?</p>
  
  <p>Something like <code>' WHERE foo = "bar"'</code> but instead of <code>=</code> it would be something like <code>' WHERE foo CONTAINS "bar"'</code>.</p>
  
  <p>Postgres Version 9.3</p>