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...)
pgsql-sql by date
|Next:||From: Tom Lane||Date: 2000-01-27 18:33:16|
|Subject: Re: [SQL] DISTINCT ON: speak now or forever hold your peace |
|Previous:||From: Gabriel Fernandez||Date: 2000-01-27 18:07:22|
|Subject: Problems with create temporary table and select ... into |