Postgres Pro
Downloads
Home   >   mailing lists

Thread: Case insensitive LIKE queries

Case insensitive LIKE queries

From
Yann Ramin
Date:
Hello,

What would be the most effective way of preforming a case-insensitive LIKE
query?  I've notived that MySQL somehow ALWAYS does it case insensitive,
which is not very smart, but I should expect this feature to exist without
reasonable pain on the programmer;s end?

Yann

--

--------------------------------------------------------------------
Yann Ramin            atrus@atrustrivalie.eu.org
Atrus Trivalie Productions    www.redshift.com/~yramin
AIM                oddatrus
Marina, CA            http://profiles.yahoo.com/theatrus

IRM Developer                   Network Toaster Developer
SNTS Developer                  KLevel Developer
Electronics Hobbyist        person who loves toys

Build a man a fire, and he's warm for a day.
Set a man on fire, and he'll be warm for the rest of his life.

"I'm prepared for all emergencies but totally unprepared for everyday
life."
--------------------------------------------------------------------

Re: Case insensitive LIKE queries

From
"Adam Lang"
Date:
select * from myTable where upper(myField) like 'TEST';

Upper will change the fields to upper case for testing purposes.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Yann Ramin" <atrus@atrustrivalie.eu.org>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, November 01, 2000 12:05 AM
Subject: [GENERAL] Case insensitive LIKE queries


> Hello,
>
> What would be the most effective way of preforming a case-insensitive LIKE
> query?  I've notived that MySQL somehow ALWAYS does it case insensitive,
> which is not very smart, but I should expect this feature to exist without
> reasonable pain on the programmer;s end?
>
> Yann
>
> --
>
> --------------------------------------------------------------------
> Yann Ramin atrus@atrustrivalie.eu.org
> Atrus Trivalie Productions www.redshift.com/~yramin
> AIM oddatrus
> Marina, CA http://profiles.yahoo.com/theatrus
>
> IRM Developer                   Network Toaster Developer
> SNTS Developer                  KLevel Developer
> Electronics Hobbyist person who loves toys
>
> Build a man a fire, and he's warm for a day.
> Set a man on fire, and he'll be warm for the rest of his life.
>
> "I'm prepared for all emergencies but totally unprepared for everyday
> life."
> --------------------------------------------------------------------
>
>
>
>
>
>
>

Re: Case insensitive LIKE queries

From
Date:
Or use the regular expression syntax for case insensitive pattern matching

e.g. SELECT foo FROM bar WHERE foo *= 'aBc';

For more info, see:
http://www.postgresql.org/users-lounge/docs/7.0/user/operators2123.htm

Hope that helps,
Ol.




select * from myTable where upper(myField) like 'TEST';

Upper will change the fields to upper case for testing purposes.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Yann Ramin" <atrus@atrustrivalie.eu.org>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, November 01, 2000 12:05 AM
Subject: [GENERAL] Case insensitive LIKE queries


> Hello,
>
> What would be the most effective way of preforming a case-insensitive
LIKE
> query?  I've notived that MySQL somehow ALWAYS does it case insensitive,
> which is not very smart, but I should expect this feature to exist
without
> reasonable pain on the programmer;s end?
>
> Yann
>
> --
>
> --------------------------------------------------------------------
> Yann Ramin atrus@atrustrivalie.eu.org
> Atrus Trivalie Productions www.redshift.com/~yramin
> AIM oddatrus
> Marina, CA http://profiles.yahoo.com/theatrus
>
> IRM Developer                   Network Toaster Developer
> SNTS Developer                  KLevel Developer
> Electronics Hobbyist person who loves toys
>
> Build a man a fire, and he's warm for a day.
> Set a man on fire, and he'll be warm for the rest of his life.
>
> "I'm prepared for all emergencies but totally unprepared for everyday
> life."
> --------------------------------------------------------------------
>
>
>
>
>
>
>






**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

SCEE
**********************************************************************