Received: from israel.diaspora.gen.nz (israel.diaspora.gen.nz [202.50.109.65]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0R5dwq98165 for ; Sat, 27 Jan 2001 00:39:59 -0500 (EST) (envelope-from rodgerd@diaspora.gen.nz) Received: from rodgerd by israel.diaspora.gen.nz with local (Exim 3.12 #1 (Debian)) id 14MO5c-0001OY-00; Sat, 27 Jan 2001 18:39:56 +1300 Date: Sat, 27 Jan 2001 18:39:56 +1300 To: pgsql-sql@postgresql.org Subject: Re: Wild Cards Message-ID: <20010127183956.A5349@diaspora.gen.nz> Reply-To: rodgerd@diaspora.gen.nz References: <94pa60$31fk$1@news.tht.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: ; from bmccoy@chapelperilous.net on Thu, Jan 25, 2001 at 02:29:55PM -0500 From: Rodger Donaldson X-Archive-Number: 200101/408 X-Sequence-Number: 1084 On Thu, Jan 25, 2001 at 02:29:55PM -0500, Brett W. McCoy wrote: > On Thu, 25 Jan 2001, wrote: > > > I am not able to get Wildcards in PostgreSQL, I know its * (asterisk), but > > its not working. can someone show me a example or something? > > Wildcards where? You can use * to mean all the fields in a table in a > SELECT statement, but if you are using LIKE in a WHERE clause, the > wildcards are % to mean any group of characters and _ to mean any single > character. Although, of course, you can use POSIXlish regexps with the ~* and ~ operators. -- Rodger Donaldson rodgerd@diaspora.gen.nz "My mother made me a lesbian" "Oh goody! If I buy her the wool, will she make me one too??"