Postgresql Contains in where clause

Question

Is there a function in postgres like `contains` ? that can be used in the `where clause` to check , whether the string passed is contained in column?

Accepted Answer

There are a bunch of ways of solving this:

Use `like`, `ilike`, and/or `SIMILAR TO` along with ||. To handle columns, something like:

```
WHERE col1 ilike '%' || col2 || '%';
```

Use position as NPE's answer

You could also use `regexp_matches` but that is more complex.

Solution