Thread: Pattern Matchig
View Single Post

   
  #3 (permalink)  
Old 04-19-2008, 06:02 PM
Tk421
 
Posts: n/a
Default Re: Pattern Matchig

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 much, it worked!

Gracias, Álvaro
Reply With Quote