It always looks simple when someone else writes it down. It never is
when I attempt to do this sort of compilicated query muself. Thank
you.
Barry
DStevens <dstevens_at_navidec.com> wrote in message news:<a6tiip$94c$1_at_newsreader.mailgate.org>...
> Ok, maybe I did miss something! :-o
>
> That'll teach me to not read the whole query!
>
> Update tblToBeSearched c set fieldfound = (Select keyword from
> tblkeywords a, tblToBeSearched b WHERE unorderedstring
> 2 LIKE '%' || keyword || '%' and c.unorderedstring =
> b.unorderedstring);
>
> 4 rows updated.
>
> Elapsed: 00:00:00.01
> SQL>
> SQL>
> SQL>
> SQL> select * from tblToBeSearched;
>
> UNORDEREDSTRING FIELDFOUND
> ---------------------------------------- --------------------
> THE QUICK BROWN FOX JUMPS
> OVER...
>
> PETER AND FRED WENT DOWN TO THE FRED
> PUB
>
> SADFSAF ASFA$$5
> SFSAFHSFU2K\\
>
> NO ***MARY*** DF\K\\ MARY
>
>
>
> DStevens wrote:
>
> > Maybe I'm missing something?
> >
> > Select keyword, unorderedstring from tblkeywords a, tblToBeSearched b
> > WHERE unorderedstring
> > LIKE '%' || keyword || '%';
> >
> > KEYWORD UNORDEREDSTRING
> > -------------------- ----------------------------------------
> > FRED PETER AND FRED WENT DOWN TO THE
> > PUB
> >
> > MARY NO ***MARY*** DF\K\\
Received on Sat Mar 16 2002 - 04:08:08 CST
