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 all things lowercase:
SELECT * FROM mytable WHERE lower(mycolumn) = 'mylowercasedata'

For regexp searching use ~* (case insensitive regexp).
Mike.
Oleg.
----
Oleg Broytmann http://members.xoom.com/phd2/ phd2@earthling.net
Programmers don't die, they just GOSUB without RETURN.

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 3 | next ›
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedApr 12, '99 at 1:40p
activeApr 12, '99 at 1:57p
posts3
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase