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
