Postgres has a load of text search operators. The most powerful is ~*whcih gives you a case insensitive regular expression search.
Adriaan