Case-Sensitivity with PHP and MySQL
| From: | midget2000x | 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