Date: Mon, 6 Nov 95 14:00:55 CST
From: jarnott@bridge.com (Jim Arnott)
Message-Id: <9511062000.AA23884@escape.bridge.com>
To: postgres95@postgres.Berkeley.EDU
Subject: Re: word/sub-word
Resent-To: owner-postgres95
Resent-Date: Mon, 06 Nov 95 11:53:56 -0800
Resent-From: pglite
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

You may want to try LIKE '% user_word %' .

Also 
	TEXT LIKE '% user_word %' 
	OR TEXT LIKE 'user_word %' 
	OR TEXT LIKE '% user_word'  

should be even more accurate.

Now, how would you do the case-insensitive ?

-jim arnott