Search code examples
sqlpostgresqlselectwhere-clausecontains

Postgresql Contains in where clause

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?

Solution

  • There are a bunch of ways of solving this:

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

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

    2. Use position as NPE's answer

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