DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:subject:content-type:content-transfer-encoding;
	b=exFMI0vzDkYLWPaYwjekvm9vWOPqsR58GWXDeDwHUWbsfzkNBABh2czCDSk0Y1ekg0NOg+03MO4HsiiJpeeT6DzGxrBiJZFCyZ8FdR3TMnmjUzWjjgI5zfFYeCqVtaV/pU0eUVBIUiPg8S37hHAxP4tLpGntH8FvoJb5igWEz7s=
Message-ID: <47FBA7F0.3000300@gmail.com>
Date: Tue, 08 Apr 2008 19:14:24 +0200
From: Tk421 <vrobador@gmail.com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Pattern Matchig
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

    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