RE: Case sensitive search
| From: | Jensen, Kimberlee | Date: | Sun, 18 Jul 2004 16:00:05 +0000 |
| Subject: | RE: Case sensitive search | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-35343@lists.php.net to get a copy of this message | ||
Two options:
1. Use ALTER to make the field BINARY.
2. Use the BINARY modifier in your SELECT
"select * from test where BINARY data='a'
-----Original Message-----
From: Rosen [mailto:rosen@pernikinfo.com]
Sent: Sun 7/18/2004 2:45 AM
To: php-db@lists.php.net
Cc:
Subject: Case sensitive search
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.
By default in MySQL comparing of strings is case-insensitive.
How can I perform a case sensitive search in text fields ?
Tnanks in advance,
Rosen