Postgresql Contains in where clause

sql postgresql select where-clause contains

You could use position() for that. It returns zero if the substring is not found:

position(col2 in col1) <> 0

sql postgresql select where-clause contains

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.

CodeHunter