Received: from hotmail.com (law-f149.hotmail.com [209.185.131.212]) by hub.org (8.9.3/8.9.3) with SMTP id LAA54004 for ; Tue, 16 May 2000 11:29:00 -0400 (EDT) (envelope-from oomoomi@hotmail.com) Received: (qmail 47375 invoked by uid 0); 16 May 2000 15:28:29 -0000 Message-ID: <20000516152829.47374.qmail@hotmail.com> Received: from 195.200.226.110 by www.hotmail.com with HTTP; Tue, 16 May 2000 08:28:29 PDT X-Originating-IP: [195.200.226.110] From: "omid omoomi" To: twallingford@indexc.com, pgsql-sql@postgresql.org Subject: Re: pattern matching operator Date: Tue, 16 May 2000 08:28:29 PDT Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-Archive-Number: 200005/10 Hi, May be you need some thing like this: Select field1, field2 from table where field1~*'string' ; Hope that helps, Omid Omoomi >From: "Wallingford, Ted" >To: pgsql-sql@postgresql.org >Subject: [SQL] pattern matching operator >Date: Tue, 16 May 2000 09:45:55 -0400 > >I need some help (the postgresql.org documentation pages are down??) > >I need to know what the pattern-matching operator is for string values in a >select query... > >select field,field from table where field ?????? 'string'; > >I want to wildcard both ends of the string.. > >Thanks! > >Ted Wallingford ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com