SEO

#1 (**permalink**) 04-19-2008, 06:01 PM

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
1 foobar
2 xxxx foobar
3 xxxx foobar yyyyy
4 foobar xxxx
5 foobars
6 foobar.
7 xxxx foobar.

What i want is to find foobar (records 1, 2, 3 and 4) but no foobars
(record 5). If i try

SELECT code FROM table WHERE text LIKE '%foobar%'

The result is 1, 2, 3, 4, 5, 6, 7. But if I try

SELECT code FROM table WHERE text LIKE '% foobar %'

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

Thank you very much.

PD: Sorry about my english

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

#2 (**permalink**) 04-19-2008, 06:01 PM

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

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

#3 (**permalink**) 04-19-2008, 06:02 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Pattern Matchig