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
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
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
PLEASE IGNORE!
Thanks!
James Kupernik [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I want to test a value that was typed into a form, but I don't want the
case
to be a problem, how can I get around this??
This is what I have now:
function
I have heard that Dezign is popular with mysql. I have downloaded it but I
never used it as the oracle support was not adequete for my needs.
http://www.datanamic.com/dezign/
Adv. Systems Design [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi:
Anyone offer