From: Dan Nelson
Date: October 14 2005 8:37pm
Subject: Re: update row/tbl question...
List-Archive: http://lists.mysql.com/mysql/190414
Message-Id: <20051014203749.GA21223@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Oct 14), bruce said:
> a basic/new/curious question. i have the following sample tbl schema.
> i do the following update on the mysql command line and it updates
> for both cases. my question is why???
>
> update UserTBL set gid='25', usertype='Super Administrator11' where username='ADmin';
> update UserTBL set gid='25', usertype='Super Administrator11' where username='admin';
> 
> 'username' = 'admin' in the tabls...

Text fields are compared case-insensitively.

http://dev.mysql.com/doc/refman/4.1/en/case-sensitivity.html

-- 
	Dan Nelson
	dnelson@stripped