PostgreSQL wildcard search for any of a list of words

Revision: 62963

at March 27, 2013 01:58 by alecolucci

Initial Code

select * from table where lower(column) similar to '%(foo|bar)%';

Initial URL

Initial Description

PostgreSQL wildcard search for any of a list of words, returns true or false depending on whether its pattern matches the given string.

Initial Title

PostgreSQL wildcard search for any of a list of words

Initial Tags

query

Initial Language

SQL