Return to Snippet

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