How to use SQL LIKE condition with multiple values in PostgreSQL

Question

Is there any shorter way to look for multiple matches    SELECT     from table   WHERE column LIKE  AAA        OR column LIKE  BBB        OR column LIKE  CCC     This questions applies to PostgreSQL 9 1  but if there is a generic solution it would be even better

User · Answer

Following query helped me  Instead of using LIKE  you can use      select id  name from hosts where name     julia lena jack

User · Answer

You can use regular expression operator      separated by     as described in Pattern Matching  select column a from table where column a     aaa bbb ccc

User · Answer

Use LIKE ANY ARRAY  AAA     BBB     CCC     as per this cool trick  maniek showed earlier today

User · Answer

You might be able to use IN  if you don t actually need wildcards    SELECT     from table   WHERE column IN   AAA    BBB    CCC

User · Answer

Perhaps using SIMILAR TO would work    SELECT   from table WHERE column SIMILAR TO   AAA BBB CCC

User · Answer

Using array or set comparisons   create table t  str text   insert into t values   AAA      BBB      DDD999YYY      DDD099YYY     select str from t where str like any     AAA     BBB     CCC        select str from t where str like any  values  AAA       BBB       CCC        It is also possible to do an AND which would not be easy with a regex if it were to match any order   select str from t where str like all      999     DDD        select str from t where str like all  values   999       DDD

[sql] How to use SQL LIKE condition with multiple values in PostgreSQL?

Examples related to sql

Examples related to postgresql

Examples related to postgresql-9.1