Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9127A475E20 for ; Tue, 22 Oct 2002 00:01:19 -0400 (EDT) Received: from hotmail.com (f102.law12.hotmail.com [64.4.19.102]) by postgresql.org (Postfix) with ESMTP id E7A39475DDC for ; Tue, 22 Oct 2002 00:01:18 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 21 Oct 2002 21:01:20 -0700 Received: from 128.123.37.101 by lw12fd.law12.hotmail.msn.com with HTTP; Tue, 22 Oct 2002 04:01:19 GMT X-Originating-IP: [128.123.37.101] From: "Zhidian Du" To: pgsql-php@postgresql.org Subject: search/select case-insensitivly. Date: Mon, 21 Oct 2002 22:01:19 -0600 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 22 Oct 2002 04:01:20.0265 (UTC) FILETIME=[ADC01790:01C2797F] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/44 X-Sequence-Number: 1559 I want a PHP program to search case-insensitivly. for example: select Name from mytable where Name = '$Name'; Here $Name is what users' input maybe JOHN, john. How to let it match John in table and find that record? Thanks. Zhidian Du _________________________________________________________________ Surf the Web without missing calls! Get MSN Broadband. http://resourcecenter.msn.com/access/plans/freeactivation.asp