ED]]
> Sent: Thursday, May 06, 1999 3:53 PM
> To: pgsql-general
> Subject:[GENERAL] Case insensitive searches
Michael, I stuck with this format for awhile, in the interests of trying
to write generic code and then the '~*' operator was just too han
ql-general
Subject: [GENERAL] Case insensitive searches
Hi,
When using mSQL I can perform case insensitive queries by using
statements
like below:
select some_field
from table
where another_field clike '%substring_
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,
When using mSQL I can perform case insensitive queries by using statements
like below:
select some_field
from table
where another_field clike '%substring_entered_by_user%'
How should I do that with PostgreSQL? (I understand 'clike' is not a
standard SQL feature and there is no simi
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
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.
And I hate to barge into a mailing list and make complaints,
