The "best" solution depends on the structure of your
data, and how many assumptions you can validly make
about it.
A generalized solution would be:
...WHERE position (test_string in field_name) > 0
which will tell you whether your string is contained
within the field contents.
If you want a case-insensitive match, use lower() or
upper() on the two strings being compared.
HTH.
--- Gregory Wood <gregw@com-stock.com> wrote:
> > I want to find a row in a table that has a column
> that matches a string
> like
> >
> > "jack nicholson - one flew over the cuckoo's nest"
> >
> > but the columns I have are:
> >
> > actor movie
> > ------ --------
> > jack nicholson One flew over the cuckoo's nest
>
> You should be able to concatenate both fields
> together (with the spaces and
> dash) when doing your search:
>
> UPDATE blah WHERE actor||' - '||movie = "jack
> nicholson - one flew over the
> cuckoo's nest";
>
> Remember, it's just a comparison operator... it just
> compares what's on the
> left side to the right, not just a single column
> with another value.
>
> > <sql idiot mode>
> > Also, if there is a DB-independent way to do this
> without a specific
> > PostgreSQL operator, that would be ideal.
> > </sql idiot mode>
>
> I believe || is SQL standard for concatenation, so
> you should be fine using
> that.
>
> Greg
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
> (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)
__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com