Rui Cunha wrote:
i suggest you to use the LIKE operator instead of the relational operator.
You should try your suggestions before you.. er, suggest them:
mysql> select 'a' like 'a';
+--+
| 'a' like 'a' |
+--+
|1 |
+--+
1 row in set (0.00 sec)
mysql>
Hi,
i suggest you to use the LIKE operator instead of the relational operator.
Rui Cunha
Rosen writes:
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
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:[EMAIL PROTECTED]
Sent: Sun 7/18/2004 2:45 AM
To: [EMAIL PROTECTED]
Cc:
Subject:Case sen
