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(at)globaldsl(dot)com>
To: Safa Pilavcı <safap(at)rt(dot)net(dot)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(at)globaldsl(dot)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...
> >
> >
> >
> >
> > ************
> >
>