Received: from www.base2inc.com (IDENT:root@www.base2inc.com [204.117.190.140]) by hub.org (8.9.1/8.9.1) with ESMTP id LAA24128 for ; Wed, 20 Jan 1999 11:04:58 -0500 (EST) (envelope-from fmorton@base2inc.com) Received: from tesla (tesla.base2inc.com [206.229.85.131]) by www.base2inc.com (8.8.7/8.8.7) with SMTP id LAA10283 for ; Wed, 20 Jan 1999 11:02:16 -0500 Message-ID: <029901be4490$147c4360$8355e5ce@base2inc.com> From: "Frank Morton" To: Subject: Faster LIKE Date: Wed, 20 Jan 1999 11:15:21 -0500 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.0810.800 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.0810.800 I have an image database with keywords assigned to each record in the field "keywords" and often do: select * from images where keywords like 'dog'; which works great with a small database, but slows down quickly with a large database. since the "keywords" field can have multiple entries, such as 'dog mammals fuzzy small' I was considering creating a separate keywords table where each word was an individual row and could therefore be indexed and fast. however, in the above example, I would like to match on "mammal" also (i.e., no "s" on the end) or any substring within the field, so the separate table does not do it either. This has to be a common thing. Are there any good solutions or research out there to solve this problem? Thanks.