Re: Simple Question: Case sensitivity
От | Abe |
---|---|
Тема | Re: Simple Question: Case sensitivity |
Дата | |
Msg-id | 000901c062aa$59e20180$6500a8c0@win2k обсуждение исходный текст |
Ответ на | RE: Simple Question: Case sensitivity ("Hancock, David (DHANCOCK)" <DHANCOCK@arinc.com>) |
Список | pgsql-general |
Thanks David, works a treat! Abe ----- Original Message ----- From: "Hancock, David (DHANCOCK)" <DHANCOCK@arinc.com> To: "'Abe '" <abe@fish.tm>; <pgsql-general@postgresql.org> Sent: Sunday, December 10, 2000 12:48 PM Subject: RE: [GENERAL] Simple Question: Case sensitivity > Abe: It's an SQL thing or a scripting thing. It's probably easiest and > safest in the SQL: > > select firstname, surname from employees > where upper(firstname) like upper('%$criteria%') or > upper(surname) like upper('%$criteria%') > > That is, force the column and the search string to uppercase befor > comparing, and it won't matter how it's stored in the database. > > Cheers! > -- > David Hancock > > -----Original Message----- > From: Abe > To: pgsql-general@postgresql.org > Sent: 12/10/00 7:23 AM > Subject: [GENERAL] Simple Question: Case sensitivity > > This is probably an easy question for most but here goes: > > I am using PHP3 and postgres 6.5 > > I am trying to do a search on a peoples database and it works fine > except > for the fact that I want to make it case insensitive as some in the > database > are Smith and some are jones. Is this a scripting thing or can it be > done > in my query. > > Here is the query: > > $sql = "select surname, firstname, title, company, worktel, ext, > hometel, > mobile, email, emailtwo from employees where firstname like > '%$criteria%' or > surname like '%$criteria%'"; > > Thanks in advance, > Abe >
В списке pgsql-general по дате отправления: