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
foobarxxxx 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