Looking for simple contains method when searching text in postgresql
There are two typical ways to express this.

With LIKE infix search:

SELECT title FROM snippets WHERE description LIKE '%evil%';


or with position:

SELECT title FROM snippets WHERE position('evil' in description) &gt; 0;


Note that neither are indexable by default. Search for "infix search index" for more info on that, and look into pg_trgm if you need it.