Re: [SQL] Pattern Matchig

2008-04-08 Thread Tk421
Alvaro Herrera escribió: 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[[:>:]]' Thank you very mu

Re: [SQL] Pattern Matchig

2008-04-08 Thread Alvaro Herrera
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 Herrerahttp://www.CommandP

[SQL] Pattern Matchig

2008-04-08 Thread Tk421
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 1foobar 2 foobar 3 foobar y 4foobar