X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 9AB13D1B89D for ; Wed, 3 Sep 2003 23:20:47 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 59400-04 for ; Wed, 3 Sep 2003 20:20:39 -0300 (ADT) Received: from hosting.commandprompt.com (214.commandprompt.com [207.173.200.214]) by svr1.postgresql.org (Postfix) with ESMTP id 57CAED1B53A for ; Wed, 3 Sep 2003 20:20:34 -0300 (ADT) Received: from commandprompt.com (dsl093-077-251.sea2.dsl.speakeasy.net [66.93.77.251]) (authenticated) by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id h83NKZC24041; Wed, 3 Sep 2003 16:20:35 -0700 Message-ID: <3F567742.9040205@commandprompt.com> Date: Wed, 03 Sep 2003 16:20:34 -0700 From: Robby Russell Organization: Command Prompt, Inc. User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5b) Gecko/20030727 Thunderbird/0.1 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Lynna Landstreet , pgsql-php@postgresql.org Subject: Re: Case sensitivity when searching for and displaying data References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/9 X-Sequence-Number: 2286 Lynna Landstreet wrote: > Hello, > > I've gotten a simple PHP search page working on the artists database that > I've been developing these past few months, but I'm running into a few > problems with PostgreSQL's case sensitivity. > PostgreSQL has regular expression capability. Try this with case-INsensitivity SELECT * FROM table WHERE name ~* 'nAmE'; If you want it without insensitive...remove the asterisk. -Robby -- Robby Russell, | Sr. Administrator / Lead Programmer Command Prompt, Inc. | http://www.commandprompt.com rrussell@commandprompt.com | Telephone: (503) 222.2783