If I want to retrieve all entries such that the column `foo` value contains a string `'bar'`, is there a simple way to do this in SQL, or Postgresql?

Something like `' WHERE foo = "bar"'` but instead of `=` it would be something like `' WHERE foo CONTAINS "bar"'`.

Postgres Version 9.3