Sender: owner-postgres95@postgres.Berkeley.EDU X-Return-Path: andrew_yu Received: from eden.CS.Berkeley.EDU (eden.CS.Berkeley.EDU [128.32.37.56]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id JAA20769 for ; Mon, 6 Nov 1995 09:42:11 -0800 Received: (andrew@localhost) by eden.CS.Berkeley.EDU (8.6.10/8.6.3) id JAA16293 for postgres95; Mon, 6 Nov 1995 09:42:09 -0800 Date: Mon, 6 Nov 1995 09:42:09 -0800 From: "Andrew K. Yu" Message-Id: <199511061742.JAA16293@eden.CS.Berkeley.EDU> To: postgres95@postgres.Berkeley.EDU Subject: (fwd) Resent-To: postgres95-redist Resent-Date: Mon, 06 Nov 95 09:42:11 -0800 Resent-From: pglite Resent-XMts: smtp Due to a glitch in the mail filter, I have to send this out manually. Sorry, Bryon. ---------------------------------------------------------- >From pglite Mon Nov 6 08:53:50 1995 Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id IAA19151 for owner-postgres95; Mon, 6 Nov 1995 08:53:50 -0800 Resent-From: Postgres95 Team Resent-Message-Id: <199511061653.IAA19151@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Received: from aztec.lib.utk.edu (AZTEC.LIB.UTK.EDU [128.169.206.31]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id IAA20259 for ; Mon, 6 Nov 1995 08:53:49 -0800 Received: from LIBPC87.LIB.UTK.EDU by aztec.lib.utk.edu (5.x/2.8s-UTK) id AA16635; Mon, 6 Nov 1995 11:52:41 -0500 Message-Id: <9511061652.AA16635@aztec.lib.utk.edu> X-Sender: bryon@128.169.206.31 X-Mailer: Windows Eudora Version 1.4.4 Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Mon, 06 Nov 1995 11:53:44 -0500 To: postgres95@postgres.Berkeley.EDU From: blape@utk.edu (Bryon S. Lape) Subject: word/sub-word Resent-To: owner-postgres95@postgres.Berkeley.EDU Resent-Date: Mon, 06 Nov 95 08:53:50 -0800 Resent-XMts: smtp For reasons that are stupid, I need to be able to let users of Web forms that search our Postgres95 databases have an option to search for a whole word or sub-word. For instance, is somone give "SONG" as a title, then for whole word match, things like "SONGS" and "SONGBOOK" would not return (they would for sub-word). My question is, how do I form these requests? Currently, I use LIKE '%user_word%', which works fine for sub-word. Any help would be highly appreciated. bryon -------------------------------------------------------------------------- No matter the law, the will is still free. Bryon S. Lape e-mail: blape@utk.edu WWW:http://aztec.lib.utk.edu/~bryon/ =============================================================================== To unsubscribe from the Postgres95 mailing list, send mail with the subject line "DEL" to "postgres95-request@postgres.Berkeley.EDU". ============ URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres95/ ===========