Re: [SQL] Fw: CONTAINS keyword

thanks but I know that command...
I am looking for more specific command as it will search in one SQL
statement for all fields...
by the way I have found this syntax

select * from my_table  where my_text_field1||my_text_field2 like
'%my_search_text%';

I am looking for a built-in function or operator that do this...

thanks....

---- Original Message -----
From: Matt Behrens <mbehrens@globaldsl.com>
To: Safa Pilavcı <safap@rt.net.tr>
Sent: Thursday, September 30, 1999 1:38 PM
Subject: Re: [SQL] Fw: CONTAINS keyword


> If you're just looking to find text within a text field, try something
> like this:
>
> SELECT * FROM table WHERE field LIKE '%foo%';
>
> This will return rows that contain the word 'foo' in table.field.  Note
> that it is a case-sensitive search.
>
> Matt Behrens <mbehrens@globaldsl.com>
> System Engineer, Global DSL Communications
>
> On Thu, 30 Sep 1999, Safa Pilavcy wrote:
>
> >  Hello,
> >   I want to use the CONTAINS keyword which enables fulltext search in
> >   database.
> >   Is it possible in Postgress..? If so How...?
> >   If not possible...is there any free database server provides this
> > feature.?
> >
> >   Thanks...
> >
> >
> >
> >
> > ************
> >
>