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: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
