Re: Case sensitive search

From:	Doug Thompson	Date:	Sun, 18 Jul 2004 13:09:28 +0000
Subject:	Re: Case sensitive search
References:	1	Groups:	php.db
Request:	Send a blank email to php-db+get-35341@lists.php.net to get a copy of this message

Rosen wrote:

Hi, I have a simple table: test ( id int unsigned NOT NULL auto_increment, data varchar(30) default NULL, PRIMARY KEY (id)) with two simple records:
id      data
1       "a"
2       "A"
When I perform "select * from test where data='a' " - it return me both rows.

http://dev.mysql.com/doc/mysql/en/Case_Sensitivity_Operators.html Doug