Posted By

alecolucci on 03/27/13

Tagged

Viewed 1100 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)%';

Comment:

You need to login to post a comment.