Received: from ifl.it (IDENT:postfix@[212.11.74.20]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA35164; Thu, 27 Jan 2000 13:21:01 -0500 (EST) (envelope-from ossvale@pixelcartoon.it) Received: from pixelcartoon.it (unknown [212.171.103.3]) by ifl.it (Postfix) with ESMTP id 91E384094; Thu, 27 Jan 2000 19:23:21 +0100 (CET) Message-ID: <38908C71.1E18DA01@pixelcartoon.it> Date: Thu, 27 Jan 2000 19:20:33 +0100 From: moreno X-Mailer: Mozilla 4.61 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-novice@postgreSQL.org, pgsql-sql@postgreSQL.org Subject: Someone can help please? SELECT problems Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: ossvale@pixelcartoon.it I have to find all records conaining a word inside a text field, with the SELECT statement. I use SELECT with LIKE operator, but I find all the fields that contain the word AND part of it, for example, if I search "data", I find also the records that contain "database". I could I do a SELECT ONLY containg the EXACT word? I use Perl 5 on linux mandrake 6.0 and the last postgres version, and would like to use the SELECT statement in a CGI-BIN to generate a HTML page (all this is already working, only the SELCT part doesn't...) thank you Valerio Oss