[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] Re: Search strings
From:       "Doran L. Barton" <fozz () iodynamics ! com>
Date:       1999-12-29 22:36:56
[Download RAW message or body]

Not long ago, Peter Landis proclaimed...
>   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.

Very possible. There are several string operators in PostgreSQL. One of my
favorite is ~* which does a case-insensitive regular expression search.

  SELECT * FROM TABLE1 WHERE FIELD1 ~* 'dog';

Hope that helps.

-=Fozz

-- 
Doran L. Barton <fozz@iodynamics.com>
Iodynamics LLC -- "Internetworking the masses"
<URL:http://www.iodynamics.com/>

************

[prev in list] [next in list] [prev in thread] [next in thread]