|
|
sybperl-l Archive
Up Prev Next
From: Thanasis Bothos <thanasis at uclink4 dot berkeley dot edu>
Subject: Re: text searching
Date: Mar 3 1998 11:09PM
One way to handle this is to configure your Sybase server to set its sort
order to 'case insensitive.
Thanasis Bothos
UC Berkeley
At 10:51 AM 3/3/98 PST, you wrote:
>Hello:
>
>This might be slightly off topic...
>
>I have a web site where I allow searching through my Sybase database
>via a HTML form and Sybperl. Currently I have it working by
>using "like '%$search_string%'", but I wish to increase the functionality
of it
>by allowing boolean and/or of the search words and the ability to
>ignore case. I believe that I could accomplish the and/or function
>by splitting apart the words from the search string and then having
>an sql statement for each search word joined with a union. Is this
>the best way to do this? How do I accomplish ignoring case?
>
>Regards,
>
>
>Philip Mikal
>philipm@nafohq.hp.com
>
>
>
|
