Posted By

alecolucci on 03/27/13


Tagged

query Postgresql postgre


Versions (?)

PostgreSQL wildcard search for any of a list of words


 / Published in: SQL
 

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

  1. SELECT * FROM TABLE WHERE lower(COLUMN) similar TO '%(foo|bar)%';

Report this snippet  

You need to login to post a comment.