Re: Case insensitive LIKE queries
От | Adam Lang |
---|---|
Тема | Re: Case insensitive LIKE queries |
Дата | |
Msg-id | 00ca01c0440f$8c172860$330a0a0a@6014cwpza006 обсуждение исходный текст |
Ответ на | Case insensitive LIKE queries (Yann Ramin <atrus@atrustrivalie.eu.org>) |
Список | pgsql-general |
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." > -------------------------------------------------------------------- > > > > > > >
В списке pgsql-general по дате отправления: