Re: "select * from table where field=hex" doesnt work

[Nils Valentin]

Hi Koh,

Shouldn't the value in the first sample be used like this ?

1) SELECT * FROM table1 WHERE field1 = '0x61006200630064000000';

Correct me if I am wrong.

Best regards

Nils Valentin
Tokyo/Japan

2003年 7月 8日 火曜日 11:55、Koh Swee Meng さんは書きました:
> i inserted a new record with this SQL
> "INSERT INTO table1(field1) VALUES(0x61006200630064000000)"
> type of table1.field1 is tinyblob.
>
> to retrieve the record, i tried SQL belows,
> 1) SELECT * FROM table1 WHERE field1 = 0x61006200630064000000;
> 2) SELECT * FROM table1 WHERE field1 LIKE 0x61006200630064000000;
> 1st SQL found nothing, but the 2nd SQL found the exact record.
>
> Is this a bug? I am using mysql 3.23.41 in Linux.
>
>
> Regards,
> Koh Swee Meng

-- 
---
Valentin Nils
Internet Technology

 E-Mail: nils@stripped
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils