Re:

Try the "like" operator

E.g. SELECT * from TABLE where FIELD like '%string%';

Don't forget the % signs - they are the wild card.

Peter Landis wrote:
>
> Hi-
>
>   I'm a newbie at postgresql and created a relational
> database with perl.  What my question is, how do you
> do a string search in postgresql?  I know you can
> search for string comparisons in oracle but was
> wondering if this is possible in postgresql?  So far
> I've been using the SELECT syntax for finding words in
> the database, but this is assuming that the word is
> exactly the same.  If anyone could advise me on this
> minor problem, I would greatly appreciate it.
>
> Peter Landis
> __________________________________________________
> Do You Yahoo!?
> Talk to your friends online with Yahoo! Messenger.
> http://messenger.yahoo.com
>
> ************

--
------------------------------------------------------------
Thomas Reinke                            Tel: (905) 331-2260
Director of Technology                   Fax: (905) 331-2504
E-Soft Inc.                         http://www.e-softinc.com