List:General Discussion« Previous MessageNext Message »
From:Koh Swee Meng Date:July 8 2003 4:55am
Subject:"select * from table where field=hex" doesnt work
View as plain text  
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

Thread
Error 1044 & Error 2003 on 4.0.13 and RH9Kevin H. Phillips4 Jul
  • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Victoria Reznichenko4 Jul
    • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Kevin H. Phillips4 Jul
    • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Nils Valentin7 Jul
      • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Nils Valentin7 Jul
        • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Kevin H. Phillips7 Jul
          • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Nils Valentin7 Jul
            • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Kevin H. Phillips8 Jul
              • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Nils Valentin8 Jul
                • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Kevin H. Phillips8 Jul
                  • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Nils Valentin8 Jul
                    • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Kevin H. Phillips8 Jul
                    • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Kevin H. Phillips8 Jul
              • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Victoria Reznichenko8 Jul
        • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Paul DuBois9 Jul
          • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Nils Valentin9 Jul
            • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Kevin H. Phillips10 Jul
              • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Nils Valentin10 Jul
                • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Kevin H. Phillips10 Jul
  • "select * from table where field=hex" doesnt workKoh Swee Meng8 Jul
    • Re: "select * from table where field=hex" doesnt workNils Valentin8 Jul
      • Re: "select * from table where field=hex" doesnt workPaul DuBois9 Jul
        • Re: "select * from table where field=hex" doesnt workNils Valentin9 Jul
  • Re: "select * from table where field=hex" doesnt workKoh Swee Meng8 Jul
    • RE: "select * from table where field=hex" doesnt workMikko Noromaa8 Jul
Re: Error 1044 & Error 2003 on 4.0.13 and RH9Nils Valentin8 Jul