Case insensitive LIKE queries

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

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
**********************************************************************