Case insesnitive searches with postgres

From: Date: Wed, 20 Sep 2000 22:35:18 +0000
Subject: Case insesnitive searches with postgres
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-3016@lists.php.net to get a copy of this message
I've tried for about a week to get the "~*" identifier to work with postgres to do a case insensitive search and haven't gotten it to work. Here's the query I'm trying to select: $result = pg_Exec( $conn, "SELECT DISTINCT author,title,price FROM books where author like '%".$Author."%' or title like '%".$Title."%' ") ; Now in this example, I don't have the "~*" included because it breaks the code. Can anyone help? Thanks

« previous php.db (#3016) next »