Received: from ant.utdt ([200.41.62.131]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA15527 for ; Tue, 16 May 2000 11:55:53 -0400 (EDT) (envelope-from mig@utdt.edu) From: mig@utdt.edu Received: (from mig@localhost) by ant.utdt (8.8.7/8.8.7) id MAA20944; Tue, 16 May 2000 12:54:52 -0300 Date: Tue, 16 May 2000 12:54:52 -0300 Message-Id: <200005161554.MAA20944@ant.utdt> X-Authentication-Warning: ant.utdt: mig set sender to mig@utdt.edu using -f To: oomoomi@hotmail.com CC: twallingford@indexc.com, pgsql-sql@postgresql.org In-reply-to: <20000516152829.47374.qmail@hotmail.com> (oomoomi@hotmail.com) Subject: Re: pattern matching operator References: <20000516152829.47374.qmail@hotmail.com> X-Archive-Number: 200005/13 You can also do it in plain SQL, no regexp: select field,field from table where field like '%string%'; >X-Originating-IP: [195.200.226.110] >From: "omid omoomi" >Date: Tue, 16 May 2000 08:28:29 PDT >Content-Type: text/plain; format=flowed >X-Mailing-List: pgsql-sql@postgresql.org >Precedence: bulk >Sender: pgsql-sql-owner@hub.org > >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 >