On Thu, 6 May 1999, Michael J Davis wrote:
> Try:
>
> select some_field
> from table
> where lower(another_field) like '%substring_entered_by_user%'
>
> -Original Message-
> From: Paulo Parola [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 0
Try:
select some_field
from table
where lower(another_field) like '%substring_entered_by_user%'
-Original Message-
From: Paulo Parola [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 06, 1999 3:53 PM
To: pgsql-general
Maybe not the fastest, but:
select some_field from table where lower(another_field) like
lower('%substring_entered_by_user%');
That will lower case the search field and item to do the match against.
--
Aaron Holtz
Hi!
On Mon, 12 Apr 1999, Mike Barnes wrote:
> Hiho ... I'd really like to know if anyone has any good suggestions for
> performing case insensitive searches on data in a 6.3 server using Perl. If
> there's some really obvious solution I'm missing, please club me over the
> head with it.
Make
