Received: from funredes.org (funredes.org [205.160.164.9]) by hub.org (8.9.3/8.9.3) with SMTP id RAA11086 for ; Thu, 19 Aug 1999 17:05:46 -0400 (EDT) (envelope-from mike@fieldco.com) Received: from mike (net1port138.tricom.net) by funredes.org (5.x/SMI-SVR4) id AA06934; Thu, 19 Aug 1999 17:08:13 -0400 Message-Id: <001f01beea87$600b7240$0300a8c0@mike> From: "Mike Field" To: Subject: multiple keyword search Date: Thu, 19 Aug 1999 17:11:15 -0400 Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001C_01BEEA65.D831EE60" X-Priority: 3 X-Msmail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3155.0 X-Mimeole: Produced By Microsoft MimeOLE V4.72.3155.0 This is a multi-part message in MIME format. ------=_NextPart_000_001C_01BEEA65.D831EE60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all- I have some text documents inside a table, just inserted normally as = text (each tuple is less than 8k). How can I search the content for = multiple keywords, for example, search content field for word1, word2, = word3 ? I understand the WHERE content LIKE '%word1%' idea, but how can I search for more than ONE keyword at a time? Most importantly, is there a way to order the results by the quality of = the match (ie, best match at the top, worst at the bottom)? Let me know. Thanks, Mike mike@fieldco.com ------=_NextPart_000_001C_01BEEA65.D831EE60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi all-
 
I have some text documents inside a table, just = inserted=20 normally as text (each tuple is less than 8k).  How can I search = the=20 content for multiple keywords, for example, search content field for = word1,=20 word2, word3 ?
 
I understand the
 
WHERE content LIKE '%word1%'
 
idea, but how can I search for more than ONE keyword = at a=20 time?
 
Most importantly, is there a way to order the = results by the=20 quality of the match (ie, best match at the top, worst at the=20 bottom)?
 
Let me know.
Thanks,
Mike
mike@fieldco.com
 
------=_NextPart_000_001C_01BEEA65.D831EE60--