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