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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]