Re: [SQL] Pattern Matchig

[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 much, it worked! Gracias, Álvaro