Case sensitive search
| From: | Rosen | Date: | Sun, 18 Jul 2004 09:45:01 +0000 |
| Subject: | Case sensitive search | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-35340@lists.php.net to get a copy of this message | ||
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