PostgreSQL regular expression :
SELECT * FROM TABLE WHERE SOMETHING ~* 'MiXeD CaSe';
~* is the regular expression operator for ignore case.
Check out http://techdocs.postgresql.org/guides/RegularExpressionIntro