Re: Pattern Matchig - Mailing list pgsql-sql

From Alvaro Herrera
Subject Re: Pattern Matchig
Date
Msg-id 20080408172409.GJ9062@alvh.no-ip.org
Whole thread Raw
In response to Pattern Matchig  (Tk421 <vrobador@gmail.com>)
Responses Re: Pattern Matchig
List pgsql-sql
Tk421 escribió:

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

Something like this:

select code from table where text ~ '[[:<:]]foobar[[:>:]]'

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-sql by date:

Previous
From: Tk421
Date:
Subject: Pattern Matchig
Next
From: Tk421
Date:
Subject: Re: Pattern Matchig