[PHP-DB] case insensitive search

[Cameron]

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


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]