Someone can help please? SELECT problems - Mailing list pgsql-sql

From moreno
Subject Someone can help please? SELECT problems
Date
Msg-id 38908C71.1E18DA01@pixelcartoon.it
Whole thread Raw
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Gabriel Fernandez
Date:
Subject: Problems with create temporary table and select ... into
Next
From: Tom Lane
Date:
Subject: Re: [SQL] DISTINCT ON: speak now or forever hold your peace