Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: A difficult SQL Query, MARY and FRED
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:33:41 CST
![]() |
![]() |