title: wild-card search in postgres
body: <p>Is there a way for me to search using wild-card <code>%</code> in Postgres to only retain the searches that have non-zero replacement of <code>%</code>? So <code>%a%</code> should only result in <code>cab</code> but not <code>a</code>.
  If not with <code>%</code>, is there another simple way to do so?
  Thanks!</p>