Received: from pcr.ca (www.pcr.ca [207.139.158.13] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id WAA24907 for ; Fri, 17 Dec 1999 22:06:03 -0500 (EST) (envelope-from admin@wtbwts.com) Received: by pcr.ca (Postfix, from userid 1000) id F0C8A1F4C; Fri, 17 Dec 1999 22:04:54 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by pcr.ca (Postfix) with ESMTP id DEEB21F43 for ; Fri, 17 Dec 1999 22:04:54 +0000 (GMT) Date: Fri, 17 Dec 1999 22:04:54 +0000 (GMT) From: admin X-Sender: admin@server.b0x.com To: pgsql-sql@postgresql.org Subject: making 'like' queries quicker Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Is there a way to make queries using the 'like' operator quicker, more specifically for queries that look like: select name from table where name like '%abc%'; Thanks, Marc