Re: [GENERAL] Case insensitive searches? - Mailing list pgsql-general

Hi!

On Mon, 12 Apr 1999, Mike Barnes wrote:
> Hiho ... I'd really like to know if anyone has any good suggestions for
> performing case insensitive searches on data in a 6.3 server using Perl. If
> there's some really obvious solution I'm missing, please club me over the
> head with it.

   Make all things lowercase:
   SELECT * FROM mytable WHERE lower(mycolumn) = 'mylowercasedata'

   For regexp searching use ~* (case insensitive regexp).

> Mike.
>
>

Oleg.
----
    Oleg Broytmann     http://members.xoom.com/phd2/     phd2@earthling.net
           Programmers don't die, they just GOSUB without RETURN.