Case-Sensitivity with PHP and MySQL

From: Date: Thu, 12 Apr 2001 03:39:07 +0000
Subject: Case-Sensitivity with PHP and MySQL
Groups: php.general 
Request: Send a blank email to php-general+get-48238@lists.php.net to get a copy of this message
I am writing a PHP script that operates on a MySQL database that uses the e-mail address as the primary key. If the e-mail doesn't exist in the database (when a form is submitted), I want to insert a new record. If it does, I want to update the existing record. How can I make the query that checks if the e-mail exists case-insensitive? I want to avoid users creating another record if they type in their e-mail in a different case. Thanks! rory ----------- providing the finest in midget technology

« previous php.general (#48238) next »