Thread: Re: [PHP] Case Insensitive Searching?

Re: [PHP] Case Insensitive Searching?

From
Kassel Ben S CRBE
Date:
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