case insensitive search
| From: | Cameron | Date: | Sat, 10 Feb 2001 08:36:32 +0000 |
| Subject: | case insensitive search | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-6525@lists.php.net to get a copy of this message | ||
im trying to do a case insensitive search in pgsql with a "WHERE blah
LIKE '%blah%'"
the problem is that currently if something contains Blah not just blah
it wont return that. suggestion? i know i can suck out every row and
then eregi them but that is majorly slow and inefficent . . .
Cameron