Posted By

alecolucci on 03/27/13

Tagged

Viewed 2221 times

Favorited by 0 user(s)

/ 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.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

SELECT * FROM TABLE WHERE LOWER(COLUMN) SIMILAR TO '%(foo|bar)%';

You need to login to view comments.