Re: A difficult SQL Query, MARY and FRED

From: DStevens <dstevens_at_navidec.com>
Date: Fri, 15 Mar 2002 12:38:05 -0700
Message-ID: <a6tiip$94c$1@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 Fri Mar 15 2002 - 13:38:05 CST