Hello everybody

I'm trying to make a query in a table to find the records who
contains a full word 'im looking for.

Here is an example about i'm trying

code text
1 foobar
2 xxxx foobar
3 xxxx foobar yyyyy
4 foobar xxxx
5 foobars
6 foobar.
7 xxxx foobar.

What i want is to find foobar (records 1, 2, 3 and 4) but no foobars
(record 5). If i try

SELECT code FROM table WHERE text LIKE '%foobar%'

The result is 1, 2, 3, 4, 5, 6, 7. But if I try

SELECT code FROM table WHERE text LIKE '% foobar %'

The result is only record number 3. How can i search the entire
FOOBAR word? The result wanted must be all, excepting 5.

Thank you very much.

PD: Sorry about my english

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql