[PHP] Case-Sensitivity with PHP and MySQL

2001-04-11 Thread midget2000x
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

Re: [PHP] Case-Sensitivity with PHP and MySQL

2001-04-11 Thread Plutarck
I had a similar question about case-sensitivity, and I was told that MySQL is automatically case-insensitive! But it depends on your version of MySQL. Go to the mysql manual and look at chapter 20.16 "Case sensitivity in searches". In the newest versions of MySQL, all searches are